SQL show selected rows from multi tables if some columns data missing

Question

I have this query:

SELECT bills.date as bills_date
     , bills.bill_nr as bill_nr
     , bills.amount as amount
     , cheques.cheque_nr as cheque_nr
     , cheques.date as cheque_date
     , cheques.amount as cheque_amount 
FROM bills 
INNER JOIN cheques ON bills.bill_nr = cheques.cheque_nr 
LEFT JOIN companys ON bills.company = companys.id 
WHERE companys.name='';

The problem that this query didn't return bill if it didn't have any cheque. Maybe someone knows how to fix it? Thank you!

Because you use an 'inner join' instead of a 'left join' on the 'cheques' table? — Raxr, Nov 30 '14 at 20:47

score 1 · Accepted Answer · answered Nov 30 '14 at 20:48

SELECT bills.date as bills_date
     , bills.bill_nr as bill_nr
     , bills.amount as amount
     , cheques.cheque_nr as cheque_nr
     , cheques.date as cheque_date
     , cheques.amount as cheque_amount 
FROM  bills
LEFT JOIN cheques   ON bills.bill_nr = cheques.cheque_nr   --<-- LEFT JOIN here
LEFT JOIN companys  ON bills.company = companys.id 
WHERE companys.name='';

SQL show selected rows from multi tables if some columns data missing

1 Answers1