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?