P
Phil Hood
Hi,
How do you compare two tables to identify records that
are in one but not the other?
For example, how would I compare tblEmployee with
tblAssets to identify any employees who do not have
assets? (Both tables contain the field employeeID)
In case it is important, one employee can have many
assets (e.g. phone, laptop, PDA etc.)
Any help gratefully received.
Thanks Phil.
How do you compare two tables to identify records that
are in one but not the other?
For example, how would I compare tblEmployee with
tblAssets to identify any employees who do not have
assets? (Both tables contain the field employeeID)
In case it is important, one employee can have many
assets (e.g. phone, laptop, PDA etc.)
Any help gratefully received.
Thanks Phil.