Hello Forums,

I have this table

user
id first type
1 jane A
2 john B

order_table
id a_id b_id
1 1 2

I left joined order_table.a_id to user.id and order_table.b_id to user.id

SELECT first FROM user
LEFT JOIN user ON order_table.a_id = user.id AND order_table.b_id = user.id
WHERE order_table.id = 1

I need to create an alias for "first" to differentiate between types.
Any ideas?

Thanks