| Subject | Re: [firebird-support] How use IN with many field? |
|---|---|
| Author | Jose Ostos |
| Post date | 2007-02-23T04:53:09Z |
Try
SELECT * FROM a
WHERE EXISTS(
SELECT * FROM b WHERE a.Fld1=b.Fld2 AND a.Fld2=b.Fld)
Jay
Pham Huu Le Quoc Phuc wrote:
SELECT * FROM a
WHERE EXISTS(
SELECT * FROM b WHERE a.Fld1=b.Fld2 AND a.Fld2=b.Fld)
Jay
Pham Huu Le Quoc Phuc wrote:
>[Non-text portions of this message have been removed]
> 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]
>
>