I have a following query which needs some refining:<BR><BR>SELECT * FROM LS LEFT JOIN LSDIVBUS ON LSDIVBUS.LSID=LS.ID WHERE DIVBUID = 1 OR ...<BR><BR>In this query LS is master table to which LSDIVBUS is linked to. LSDIVBUS does NOT contain all the ID values that exist in LS. But i want to make a query that lists all records in LS table with a certain DIVBUID value AND the ones that don&#039t have any. Please note that NULL does NOT work in this case because the record simply does not exist in LSDIVBUS table.<BR><BR>Olli<BR>