Joining two tables

[thendal]

Hi all!

I am new to Mysql. I have two tables say table1 and table 2.

both have an field name id. I need all ids from table1 thats not in table 2.

i tried something like this in mysql ..

select table1.id from table1 where table1.id =! table2.id;

error message unknow where clause table2

didn't work ...

then i tried something like this ....

select t1.id from table1 AS t1,table2 AS t2
where t1.productid != t2.productid;

didn't work .....asked me to check the mysql manual and server version .....

server version : 4.0.12-log
client version : 3.23.33

Any help will be greatly appreciated.

Thanks

 

[sleipnir214]

Something like:

SELECT
table1.id
FROM
table1 LEFT JOIN table2
ON table1.id = table2.id
WHERE table2.id IS NULL

should do it.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[thendal]

Thank you very much sleipnir214.

Got sick last week.