SQL join problems

[Steve Penney]

Hi There,

I suspect what i am trying to achieve cant be done but I thought I'd ask those much smarter than me before I try another approach.

Basically I have a table with items for sale. I also have a table with item images with a FK linked to the for sale items PK.

I was hoping to write 1 query to select all items from for sale table and the primary image in the linked table.
EG "SELECT tblForSaleItems.id, tblForSaleItems.desc, tblForSaleImages.imagePath FROM tblForSaleItems JOIN tblForSaleImages on tblForSaleItems.id = tblForSaleImages.FK_ForSaleItems where tblForSaleImages.primaryImage = 1"

This works fine until I have a for sale item with no corresponding image in the images table, as I would expect.

Is there a way to rewrite the query so that if there is no corresponding image, it will still return the for sale item with a null value for imagePath that I can catch in my PHP code?