whit3fir3 Posted December 20, 2009 Share Posted December 20, 2009 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 More sharing options...
whit3fir3 Posted December 20, 2009 Author Share Posted December 20, 2009 I found a way to do what I wanted. A simple WHERE test using ISNULL() function returns the results that I am looking for. Link to comment https://forums.phpfreaks.com/topic/185732-sql-statement-help/#findComment-980717 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.