I'm looking for a way to select data from one table that is not found in
another. I am sorting on a column called 'model_id'. Basically I want
something like this to work:
"SELECT t1.*, t2.model_id FROM data1 as t1, data2 as t2 WHERE
t1.model_id != t2.model_id"
t1 has about 1000 entries and t2 has around 500. Unfortunately when I
run this SQL query mySQL seems to hang up and never produces any data.
I'm running this through PHP and trying to display the information
returned on a webpage. If you need any other info in order to help me,
let me know.
Thanks in advance,
-Nate
