Level 102
Show the output of
$data = Table1::selectRaw("COALESCE(table1.name, 'empty') AS name")
->leftJoin("table2", "table1.id", "=", "table2.id")
->dd()
Dec 22, 2022
5
Level 8
Ambiguous column name when using selectRaw, coalesce and join
I have the following join query:
$data = Table1::selectRaw("COALESCE(table1.name, 'empty') AS name")
->leftJoin("table2", "table1.id", "=", "table2.id")
->get()
I specifically chose the name from table 1 yet I still get ambiguous column error
Why?
Level 8
@Sinnbeck I'm sorry, I forgot that I had a groupBy, where I also needed to add it: groupBy('table1.name', ..)
Level 102
@Ligonsker So it is solved or ?
1 like
Level 8
@Sinnbeck Yes
Level 74
This means that you have two columns with the same name
Ambiguous column name
you need to specify which table it comes from.
Please or to participate in this conversation.