Timeline for Confusion about using two select() method calls in one query
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 26, 2018 at 18:33 | comment | added | FFrewin | @WilliamZhao - do you ask how the actual MySQL query would look like? With a quick look what you wrote above seems correct. You can use echo $query->dump(); and it will print the actual query. | |
| Sep 26, 2018 at 17:59 | comment | added | William Zhao | select a.id as id, a.greeting as greeting, a.published as published from #__diolegend as a select c.title as category_title left join #__categories as c on c.id = a.catid ????? | |
| Sep 26, 2018 at 17:56 | comment | added | William Zhao | +1 Ah yes I have changed the #__diolegend to #__categories, thanks, how sql stamens would be in this case? | |
| Sep 26, 2018 at 17:49 | history | answered | FFrewin | CC BY-SA 4.0 |