0

Can you please help me solve the error

SELECT user_id, firstname, id, office_name, lastname, email, office_name
    
    FROM users u JOIN offices o on o.id = u.office_id
Justin Dev
  • 1
  • 2
  • 1
    tl;dr where a column exists in more than one table you need to alias it. For example, if `id` exists in both `users` and `offices` then Oracle doesn't know whether you want to use `users.id` or `offices.id` so you need to choose, e.g. `o.id`. – Ben Jun 24 '22 at 16:00
  • I would go even further, and alias all the columns for queries that include multiple columns. – The Impaler Jun 24 '22 at 16:05

0 Answers0