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]