Try this.
SELECT Name, u_country, u_postcode FROM user
WHERE u_postcode NOT IN (SELECT d_postcode FROM data)
Hope it helps
Jerry
2010-05-19 04:39:48
+4
A:
Correct one result
Karthik
2010-05-19 04:47:09
@jerry: can i use another subquery or AND NOT EXISTS ? i'm affraid IN will be problem in performance. any idea?
apis17
2010-05-19 05:18:29
anyway this code works. thanks..
apis17
2010-05-19 05:33:58
pls see updates:
apis17
2010-05-19 05:43:29
if i put GROUP BY u_postcode, the u_country for Name 3 will be blank. how to display Name3 and Name4 as unique?
apis17
2010-05-19 06:02:11
ok nvm, i solved uniqe problem using SELECT DISTINCT command. thank you all.
apis17
2010-05-19 13:19:33