Also add Dept table
Then click Close
SQL script created as
SELECT EMP.*, DEPT.LOC
FROM EMP INNER JOIN
DEPT ON EMP.DEPTNO = DEPT.DEPTNO
Saved this query with a suitable name
| SQL_QueryDesigner1 |
| SQL Server 2005 Query Designer
|
|
| Select Query Designer
|
| Selecting tables and columns (click Add)
Also add Dept table
Then click Close |
| Example of Inner Join
SQL script created as SELECT EMP.*, DEPT.LOC
Saved this query with a suitable name
|