Right join or left join

Databases
7 
SELECT minerals.mineral
     , bank.amount
     , members.credits AS cash 
  FROM members 
LEFT OUTER 
  JOIN bank 
    ON bank.userID = members.userid
LEFT OUTER
  JOIN minerals
    ON minerals.id = bank.minerID
 WHERE members.userid = 1

pro tip: never use RIGHT JOINs

1 Like