RE: For the SQL gurus: Is this practical? Is it even possible?

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: James HH. Lampert
>
> Consider the following scenario:

Does this work?

SELECT * FROM FOO WHERE
  EXISTS (SELECT 1 FROM QUUX, BAR WHERE QUUX.FOOKEY = FOO.KEY
          AND QUUX.RECTYP = 'BAR' AND QUUX.SUBKEY = BAR.KEY AND
          BAR.FWEEP = 2) AND
  EXISTS (SELECT 1 FROM QUUX, BAZ WHERE QUUX.FOOKEY = FOO.KEY
          AND QUUX.RECTYP = 'BAZ' AND QUUX.SUBKEY = BAZ.KEY AND
          BAZ.BOZ = 'SPAM') AND
  EXISTS (SELECT 1 FROM QUUX, GAZONK WHERE QUUX.FOOKEY = FOO.KEY
          AND QUUX.RECTYP = 'GAZ' AND QUUX.SUBKEY = GAZONK.KEY AND
          GAZONK.GRIFFY = 3.14159)

Performance in SQL as always depends on indexes.

Joe