Question

SQL - Microsoft Access

---------------------------------------------------------------------

SQL- Microsoft Access List the employee number, employee last name, and pilot license type (if any) for all employees. (Hint: LEFT oUTER JOIN or OUTER JOIN must be used, because "if any"-some of them are not pilots). EMP NUM EMP TITLE EMP LNAME EMP FNAME EMP INITIAL EMP DOB EMP HIRE_DATE Click to Add 100 Mr 101 Ms. 102 Mr 103 Ms. 104 Mr 105 Mr 106 Mrs 107 Mr 108 Mr 109 Ms. 110 Mrs Kolmycz Lewis Vandam Jones Lange Williams Duzak Diante Wiesenbach Travis Genkazi Monday, June 15, 1942 Friday, March 15, 1985 Friday, March 19, 1965 Friday, April 25, 1986 Friday, May 18, 1990 Friday, July 26, 1996 Monday, July 12, 1971 Monday, August 20, 1990 Friday, March 14, 1975 Saturday, June 19, 1999 Monday, February 12, 1968 Monday, March 13, 1989 Thursday, May 1, 1975 Saturday, July 2, 1994 Sunday, June 3, 1990 Sunday, June 18, 1961 Friday, April 14, 1989 Friday, June 29, 1990 Rhett Anne John Robert Jeanine Jorge Paul Elizabeth Leighla Friday, November 14, 1958 Saturday, May 11, 1974 Monday, February 14, 1966 Tuesday, May 19, 1970 ▽| Monday, April 12, 1999 Thursday, June 10, 1999 Thursday, February 25, 1999 Friday, April 2, 1999 Wednesday, April 14, 1999 ▽| Click to Add EMP-NUM ▽| PIL-LICENSE ▽| PIL RATINGS SEL/MEL/Instr/CFI SEL/MEL/Instr SEL/MEL/Instr/CF SEL/MEL/Instr SEL/MELUSES/Instr/CFII1 ▽| PIL-MED TYPE ▽ PIL MED DATE PlL PT135 DATE ▽ 101 ATP 104 ATP 105 COM 106 COM 109 COM Tuesday, June 15, 1999 Tuesday, March 23, 1999 Friday, February 12, 1999 Monday, May 24, 1999 Wednesday, April 21, 1999 2 2

Answer 1

SELECT EMP_NUM, EMP_FNAME, PIL_LICENSE FROM EMPLOYEETABLE E JOIN PILOTTABLE P ON EMPLOYEETABLE.EMP_NUM=PILOTTABLE .EMP_NUM

Left outer join returns all the rows in the left table, i.e.employeetable and only matching rows from the right table, (here pilottable) and returns null for the values which are in table1 but not in table2