| Subject | How use IN with many field? | 
|---|---|
| Author | Pham Huu Le Quoc Phuc | 
| Post date | 2007-02-23T04:10:23Z | 
I want to write a following query
 
select *
from A
where a.field1, a.field2
in
(select B.field1, B.field2
from B)
[Non-text portions of this message have been removed]
            select *
from A
where a.field1, a.field2
in
(select B.field1, B.field2
from B)
[Non-text portions of this message have been removed]