Subject Sub Query Param
Author Koby Peleg Hen
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@...