For experts to solve this, another thread needs to be read first.
Earlier I asked how to compare 2 tables in order to exclude records from one of them. That was solved (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27869482.html
I later learned that I needed to be able to query and display all the columns available from the subquery - and all data must be contained within the same SQL statement.
The accepted answer was this statement:
select * from tbl01User
where not exists (select null from tbl055PaidMembers where tbl01User.pkIntUserID = tbl055PaidMembers.fkIntUserID and isnull(tbl055PaidMembers.strPaid,0) = '1');
Now - the table called tbl055PaidMembers
is the one that I need to be able to query and display.
I hope my question makes sense :)