Hello Forums,

I have this table

id first type
1 jane A
2 john B

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?