Re: SELECT (SELECT.....) bugging me

anneke_at_echelon.nl (Anneke Treep) writes:

Hi!

>SELECT id,
> (SELECT count(*) FROM appt WHERE id = 10),
> dob
>FROM persons
>WHERE id = 10;

This should do the work:

SELECT a.id, count(*), a.dob
FROM persons a, appt b
WHERE a.id = 10 AND b.id = 10;

--
TK Received on Wed May 05 1999 - 05:23:18 CDT