Jump to content

SQL Statement Help...


whit3fir3

Recommended Posts

I have a select statement that I am working on and can not figure out to get it to perform the look up that I want.  I have 2 tables that I am doing a JOIN on.  One table is a list of items and the other table is a list of images that relates to the item.  Each item can have many images so the table relationship is more or less a ONE to MANY relationship.  I am finding that items are getting added with out images and I am trying to find a way to search the database for ITEMs that do not have images.  My question is, is there a INVERSE or NOT function in MySQL that would return the any records that do not have images when I perform the JOIN?

 

Thanks,

 

Whit3fir3

Link to comment
https://forums.phpfreaks.com/topic/185732-sql-statement-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.