>>I would do it in one of two ways (in the order of my personal preferences)
>>

SELECT PrimaryKey, DataItem ;
>>  FROM TableA ;
>>  WHERE PrimaryKey IN ( SELECT PrimaryKey FROM TableB WHERE Condition = .T.)
>>*
>>SELECT PrimaryKey, DataItem ;
>>  FROM TableA ta ;
>>  WHERE EXISTS ( SELECT * FROM TableB tb ;
>>        WHERE ta.PrimaryKey = tb.PrimaryKey AND tb.Condition = .T.)
>>

>
>Would either of these or the options in the other thread work if TableB were a pre-existing view instead of a SELECT?

The above two should work. I don't remember what other options were suggested.

>
>> You may want to take a look at recent discussion which one is faster. ?
>> Re: How to use select... where EXISTS ... ? Thread #793069.
>
>Still reading and digesting it. Thanks.