>I want a list of table1.id not included in Table2 but i don't find the
>solution!
SELECT *
FROM table1 LEFT JOIN table2 USING (id)
WHERE table2.id IS NULL
PB
> select table1.id from table1 left outer join table2 on table1.id =
table2.id
> where table2.id = NULL;
Sorry, that last should be
where table2.id IS NULL;
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
> I want a list of table1.id not included in Table2 but i don't find the
> solution!
I _*think*_ this will work for you. If I'm wrong, I'm sure someone
will come behind and correct me:
select table1.id from table1 left outer join table2 on table1.id = table2.id
where table2.id = NULL;
Chris
Hi, i've a little problem with query.
I have two tables where
Table1
id
desc
Table2
id
desc
I want a list of table1.id not included in Table2 but i don't find the
solution!
Example
Table1:
---
id ! Desc
---
1! xx
2! Xx
3