Hello!

Does IB 6 supports SELECT statement in the search condition of
select_expr?

Details are as follows...

I get the following ERROR

"Dynamic SQL Error
SQL error code = -206
Subselect illegal in this context"

Thus...in a Procedure definition

Create Procedure Proc_1

AS

BEGIN
IF (EXISTS (SELECT * FROM Table1 T1 Table2 T2
WHERE T1.Col_m = T2.Col_n
AND T1.Col_k = j))
THEN
BEGIN
UPDATE ....
....
....
....
END
ELSE
BEGIN
DELETE....
....
....
END
END
^

Any advice could be great!

Thanks & Regards

Krishna Kumar