tblCompany co (PK, varchar(10), not null)

name (varchar (50), not null)

tblEmployees co (PK, FK, varchar(10), not null)

id (PK, varchar(10), not null)

ssn (varchar(11), not null)

lastName (varchar(40), not null)

firstName...

Thanks Lynn that is what I was looking for as a start. As for the validation, that is why I included the rules fron US.gov website for how to...

I guess am not getting your question because i don't need to validate anything all i need is a query that returns any Employees (id, ssn, and name) with an...

Basically looking to use a JOIN on the two tables to find invalid ssn using the invalid rules listed.

Using “_” which would only match a single character and thus would not match the intended records. Also, I updated to add the birthday field which basically is necessary to...