|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 16th, 2004, 07:40 PM
|
||||
|
||||
|
Inner Join Help
I need a bit of help with an INNER JOIN for a set of pages I am putting together. I am afraid I'm just not proficient in JOINS. I am creating a site that contains (1st table) a list of PPRs (performance and policy reviews) and (2nd table) a list of employees. The 3rd table in the database will show a list of userIDs and pprIDs then display whether the user has completed the PPR or not (a simple Yes/No).
Could I get some help with the INNER JOIN for the SQL statement? Table1 (PPR) pprID pprTitle pprSummary pprAuthor pprIssueDate pprDueDate Table2 (USERS) userID userLogin userPass userFName userLName userSecLevel userSupervisor Table3 (ISDONE) isDoneID userID pprID isDone Muchos Grass!
|
|
#2
February 17th, 2004, 09:40 AM
|
||||
|
||||
|
Code:
SELECT A.*, B.*, C.* FROM [USERS] A INNER JOIN IsDone B On (A.UserID = B.UserID) INNER JOIN PPR C On (B.pprID = C.pprID)
|
|
#3
February 17th, 2004, 10:41 AM
|
|||
|
|||
|
SELECT A.*, B.*, C.*
FROM [USERS] A Left outer Join IsDone B On (A.UserID = B.UserID) INNER JOIN PPR C On (B.pprID = C.pprID) Quote:
|
|
| Viewing: ASP Free Forums > Database > SQL Development > Inner Join Help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
