>Hi Dave,
>
>You can still create this same SQL in a view using the view designer without any problems. In the Filter Page of the view designer setup your where condition and it will work.
>
>
>>Hi John,
>>I finally gave up on the View Designer and just made the RowSourceType - 3-SQL
>>
>>and put the following in the RowSource:
>>
>>select st_status,st_id from status where st_id in (select notes.st_id from notes) into cursor Ct_stats
>>
>>
>>Thanks
Hi Kamal...how ya' been?
Yea, I was trying to use the "IN" operator like the "$" operator in the VD.
IOW, the IN clause was like ..."IN "AAAAAB","AAAAAC" ratner than another select statement.
All is well now...thanks...see ya!
Best
Dave