duplicate record issue

[Bazrut]

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

[noobi]

Hello Bazrut,
You should be able to compare those fields as soon as you place them your detail section.
You can also use the selection expert to filter your results.
I also recommend you look at the "inner join" information available at http://www.w3schools.com/ - look uder SQL