SQL Left Join返回的内容少于预期

I have a database, and I need to get data that is on the table PEDIDOC mixed in with FALTANTE, but I need to do a left join because I need ALL the data in PEDIDOC even if there is no matching FALTANTE. I have triple checked and all information is inputed correctly and everything is there, if I just do Select * FROM pedidoc I get what I expect when I filter it in Excel, but when I do my left joins, then there are productos missing.I have a database, and I need to get data that