query

[Patricio Gigoux]

Hello:
I have 2 tables
t1:
id      age
1       7
2       6
3       7
4       8
5       9
6       4

t2:
age
7
9

then I like select all in t1  without are in t2, so I need a result as follow
id      age
2       6
4       8
6       4

Thanks in advance 

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