Subject | Re[2]: [ib-support] PLAN and stored procedure |
---|---|
Author | Roland Turcan |
Post date | 2002-08-16T14:25:49Z |
<<< 16. 8. 2002 16:24 - Svein Erling Tysvćr "svein.erling.tysvaer@..." >>>
SET> SELECT DISTINCT Verzeichnislinks.AID
SET> FROM Verzeichnislinks
SET> WHERE EXISTS (SELECT 1 FROM CreateVidListe(12002) CVL WHERE CVL.VID =
SET> Verzeichnislinks.VID)
But, Select 1 from Table returns one column with value 1 on number of
rows like is result of CreateVidListe SP with where condition.
--
Best regards, TRoland
http://www.rotursoft.sk
SET> SELECT DISTINCT Verzeichnislinks.AID
SET> FROM Verzeichnislinks
SET> WHERE EXISTS (SELECT 1 FROM CreateVidListe(12002) CVL WHERE CVL.VID =
SET> Verzeichnislinks.VID)
But, Select 1 from Table returns one column with value 1 on number of
rows like is result of CreateVidListe SP with where condition.
--
Best regards, TRoland
http://www.rotursoft.sk