Date: 04/18/07 (SQL Server)    Keywords: sql

I have a multiple-table query that will involve either a left or right join, but am not sure how to approach this.

table PERSON is primary table, with PK ID
table SKILL is primary table, with PK SID
table PERSON_SKILL is foreign m-to-m table, with FK PID = PERSON.PID and FK SID = SKILL.ID
table PERSON_JOBS is foreign table, with FK PID = PERSON.ID, 1 to 1

I would need to query all these at once. How accurate is this?

SELECT p.* pj.job, ps.skill
FROM PERSON p
INNER JOIN PERSON_SKILL ps on ps.pid = p.id
INNER JOIN SKILL s ON s.id = ps.sid
INNER JOIN PERSON_JOBS pj ON j.pid = p.id

Source: http://community.livejournal.com/sqlserver/57623.html