There was a mistake in the first post....This is the sql I intended to
ask about:

if (exists (select 1 from TABLEONE
where COL_IN_TABLEONE in(select COL_IN_TABLEONE from TABLE
where (COL_IN_TABLETWO = "aValue"))
and HISTORIE > 0 )
) then
begin
.
.
.
end


Henrik

-----Original Message-----
From: Henrik Sitter [mailto:henrik.sitter@...]
Sent: 25. januar 2004 21:02
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Is this legal SQL?

Hi, I have a stored procedure and need a bit of help with some sql.
Basically, is this legal sql?

if (exists (select 1 from TABLEONE
where COL_IN_TABLEONE in(select COL_IN_TABLEONE from
TABLETWO where
(COL_IN_TABLEONE = "aValue")
)
and HISTORIE > 0
)
) then
begin
.
.
.
end

Thx,
Henrik





Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/