Re: How do I get this query to work?

>> Are you arguing that you would create and autoID field for a person
table for the payroll system of a US based company?
Using SSN in that case is appropriate (even though it is a pseudo key
itself but that's a higher level discussion), even if they 'can be made

up or stolen'. <<

Using SSN would render the system useless if (or when) the users expand
internationally

.