On Mon, 20 Aug 2001, Joseph Shraibman wrote:
> I want to select a boolean if there exists a row in another table that matches this one.
> So I did select ..., (select count(*) from table2 where ...) > 0 ...
> but that count(*) was taking forever. I know there is a better way to do it, but whenever
> I try to use EXISTS I get a syntax error. What is the proper way?
Hmm, on current sources I can do:
select ..., exists (select * from table2 where ...) from table1;
I don't know if that's new though...