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. |