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    ! ZZ

Table2: 
-----------------------
 id   ! Desc
-----------------------
 1    ! xx 
 2    ! Xx
 4    ! YY

I would like as Result this: 
-----------------------
 id   ! Desc
-----------------------
 3    ! ZZ



Thanks for any suggestions.

Massimiliano 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to