1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Finding Unique records in multiple tables

Discussion in 'MS Access' started by oziking, Aug 10, 2010.

  1. oziking

    oziking New Member

    Joined:
    Aug 10, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi:
    I have this query to match Student ID in Results1 and Results2. And display the results
    Now i want to modify it to search in Results3 and Results 4 table also?
    How can i do it
    Further R1 appears in all 4 Results tables. Can i Show the Max R1 vaule only in one column after searching ? instead to showing R1 from all tables??
    Code:
    SELECT Students.StudentID
         , Students.Fullname
         , Results1.R1 AS Results1_R1 
         , Results1.R2 AS Results1_R2
         , Results2.R1 AS Results2_R1
         , Results2.R2 AS Results2_R2    
      FROM [COLOR=Red][B]([/B][/COLOR]
           Students
    LEFT OUTER
      JOIN Results1
        ON Results1.StudentID = Students.StudentID
           [COLOR=Red][B])[/B][/COLOR]
    LEFT OUTER
      JOIN Results2
        ON Results2.StudentID = Students.StudentID
    
     

Share This Page