Sure here is an example you could tweak to work in your case:

SELECT *

FROM employee INNER JOIN department

USING (DepartmentID);

The...

Thanks for the reply.

From what I was reading it seems as though the USING syntax worked back in version 7 and Sql Server 2000 based on an older...