| Subject | Is this legal SQL? |
|---|---|
| Author | Henrik Sitter |
| Post date | 2004-01-25T20:02:16Z |
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
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