Ok quite new to crystal reporting but done some basics and got the hang of it I think.

Now I am getting more involved with reporting from active SQL tables. Issue I have at the momnet is that I have 2 tables. One has a list of personal data and one has a list of system users. They have a couple of identical columns including a unique user id(employee id number).

What I want is a report which can be run to list everyone that only appears in table A (Personal Data).

So my logical thinking is i should be able to look at table A and compare with table B and if the ID number is in table B ignore it from Table A.


Anyone ever have to do this before?


Cheers
Baz