CODEWITHSUNDEEP
sqlselectrowno-data
Rytis
Rytis

Reputation: 99

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

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!

Upvotes: 0

Views: 73

Answers (1)

M.Ali
M.Ali

Reputation: 69524

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='';

Upvotes: 1

Related Questions