tomdchi Posted December 14, 2008 Share Posted December 14, 2008 I have the query: SELECT tblinvoiceitems.invoiceid, tblinvoices.id FROM tblinvoiceitems LEFT JOIN tblinvoices ON tblinvoiceitems.invoiceid = tblinvoices.id This produces : invoiceid id 6599 6599 6599 6599 6599 6599 6609 6609 6609 6609 6609 6609 6609 6609 6620 6620 6620 6620 6621 6621 6621 6621 6621 6621 6621 6621 6623 NULL 6624 NULL 6625 6625 7589 NULL I need this to go further and retrun only records that have 'NULL' in the id column. I have tried various ways but can't get it to work. It would show only the 3 records from above with NULL: invoiceid id 6623 NULL 6624 NULL 7589 NULL Can anyone help me with this? Thanks, Tom Link to comment https://forums.phpfreaks.com/topic/136975-solved-cant-figure-out-last-part-of-join/ Share on other sites More sharing options...
xtopolis Posted December 14, 2008 Share Posted December 14, 2008 Perhaps: SELECT tbi.invoiceid, ti.id FROM tblinvoiceitems tbi LEFT JOIN tblinvoices ti ON (tbi.invoiceid = ti.id) WHERE ti.id IS NULL Untested Link to comment https://forums.phpfreaks.com/topic/136975-solved-cant-figure-out-last-part-of-join/#findComment-715441 Share on other sites More sharing options...
tomdchi Posted December 15, 2008 Author Share Posted December 15, 2008 Perfect! I was missing the () on the (tbi.invoiceid = ti.id) Link to comment https://forums.phpfreaks.com/topic/136975-solved-cant-figure-out-last-part-of-join/#findComment-715514 Share on other sites More sharing options...
xtopolis Posted December 15, 2008 Share Posted December 15, 2008 actually, I think the () are optional in this case.. http://dev.mysql.com/doc/refman/5.0/en/join.html at least it works~ Link to comment https://forums.phpfreaks.com/topic/136975-solved-cant-figure-out-last-part-of-join/#findComment-715516 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.