Fun with inner join

You know any alternative of INNER JOIN??

Here is it....

Table Structure:

Employee Table
LastName	DepartmentID
Rafferty	31
Jones	33
Steinberg	33
Robinson	34
Smith	34
Jasper	NULL

Department Table
DepartmentID	DepartmentName
31	Sales
33	Engineering
34	Clerical
35	Marketing

ORIGINAL ONE:

SELECT Employee.lastName, Employee.DepartmentID, Department.DepartmentName

FROM Employee INNER JOIN Department

ON Employee.DepartmentID = Department.DepartmentID;

ALTERNATIVE ONE:

SELECT Employee.lastName, DepartmentID, Department.DepartmentName

FROM Employee INNER JOIN Department

USING(DepartmentID);

Happy Coding :)