Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
4 years ago
Solved

LEFT OUTER JOIN not working

Hello, i've a table A with the follow: code_ID    department     costs 1               chemistry        100 2               math                200 3               sociology         300 4      ...
Need Help
  • Jos_Woolley's avatar
    Jos_Woolley
    4 years ago

    If the matching is to be based on all 3 columns:

    NewTable =
EXCEPT ( Table1, Table2 )

    Regards