Laravel / Sql: How to join different table with condition

Question

I have an table A contain account_id and type

If type = 1 -> account_id will join with table User
If type = 2 -> account_id wwill join with table Customer

I have no idea how to write an SQL query?

Please help

Why not use PHP to decide?

mighty_dev
– mighty_dev

2017-11-18 16:41:56 +00:00
Commented Nov 18, 2017 at 16:41 — mighty_dev
– mighty_dev, Commented Nov 18, 2017 at 16:41

Gordon Linoff · Accepted Answer · 2017-11-18 16:04:50Z

1

In SQL, you would write this with two left joins:

select a.*,
       coalesce(u.name, c.name) as name  -- how you access a field
from a left join
     users u
     on a.account_id = u.user_id and a.type = 1 left join
     customers c
     on a.account_id = c.customer_id and a.type = 2;

answered Nov 18, 2017 at 16:04

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel / Sql: How to join different table with condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related