Compare 2 tables to exclude records from one of them
Posted on 2012-09-18
I have 2 tables.
Table A: Users (members of my site).
Table B: Users who paid for membership at my site.
At Table B: there is a field called strPaid. If there is a value (1), then the users has paid for its membership.
There is a relation (one to many) from A to B:
Table A: - primary key is the pkIntUserID
Table B: - foreign key is the fkIntUserID
Here is what I want:
I want to users who have paid NOT to appear on a view
I realize that it's not gonna happen if I create a normal view using these 2 tables.
How should I do it?