Subject | Sub Query Param |
---|---|
Author | Koby Peleg Hen |
Post date | 2003-08-04T12:54:36Z |
Hello All
Can some one please help me with this query.
I want to be able to connect that param bellow
With "MasterLinks" Or With "MasterParamLinks"
and it always return with an error who look like this:
"the CLient_ID is unknone column"
SELECT distinct CLIENT_INTEREST.INTEREST_ID,
CLIENT_INTEREST.INTEREST_SUBJECT
FROM CLIENT_INTEREST
where Client_Interest.Interest_ID Not IN
(Select Client_Interest_ID
From Client_Belong_Interest
Where Client_id = :ID);
IS this mean that i can not assign param into a sub query ?
--
Thank you for your time
Koby Peleg Hen
koby@...
Can some one please help me with this query.
I want to be able to connect that param bellow
With "MasterLinks" Or With "MasterParamLinks"
and it always return with an error who look like this:
"the CLient_ID is unknone column"
SELECT distinct CLIENT_INTEREST.INTEREST_ID,
CLIENT_INTEREST.INTEREST_SUBJECT
FROM CLIENT_INTEREST
where Client_Interest.Interest_ID Not IN
(Select Client_Interest_ID
From Client_Belong_Interest
Where Client_id = :ID);
IS this mean that i can not assign param into a sub query ?
--
Thank you for your time
Koby Peleg Hen
koby@...