Combine these query in one query

Viewed 16

I want combine these query in one query line

SELECT bizzes.*, users.name AS OwnerName FROM bizzes LEFT JOIN users ON users.id = bizzes.Owner;
SELECT bizzes.*, users.name AS PartnerName FROM bizzes LEFT JOIN users ON users.id = bizzes.Partner;

I want my result is all from bizzes and OwnerName and PartnerName if find it

0 Answers
Related