[SOLVED] Stuck,, need help to formulate this topic

[elpaisa]

Hi all! 

 

I don't know how to formulate this topic cos I have a mess in the quite big head. 

 

I need to take "imageid" and "title" fields from one table called images and take another "imageid" related of a second table, then to compare what imageids from the first table are not in the second table to show the records of the first one without showing the records whose imageid is in second table.

 

All comments and help are welcome!

Regards.

[GingerRobot]

If memory serves, then the query should be:

 

SELECT table1.imageid, table1.title FROM table1 LEFT JOIN table2 USING imageid WHERE table2.imageid IS NOT NULL

[revraz]

May have to use LEFT JOIN for that.

[elpaisa]

Yes i used left join but shows the records existent in both tables  for imageids related, what i need to do is show only records from table1 whose ids are not in table2

[elpaisa]

I think is just a simple left join query, but. Do i need some extra code to echo records only from table one?

[elpaisa]

Solved!

 

 

SELECT sd_p17_images.imageid, sd_p17_images.title FROM sd_p17_images

          LEFT JOIN sd_p17_meds ON sd_p17_images.imageid = sd_p17_meds.imageid

          WHERE sd_p17_meds.imageid IS NULL;