View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 08:31 AM
incogni@gmx.de
 
Posts: n/a
Default Mysql 4.0 without subselects, select 2 tables

Hello

2 simply tables

table1
Clientid col1
1 A
2 A
3 B

table2
Clientid col1 col2
1 A A
1 A B
1 B A
2 A B
2 B A
3 A A
3 B A

i'm searching Clientid's which have in table1,col1 an A and in table2
with same clientid DONT have a row A A

result is Clientid 2

can anyone help me

thanx
inc.

Reply With Quote