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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/185732-sql-statement-help/#findComment-980717 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.