2021-06-27

get specific column name from joined tables [duplicate]

I need to get just the columns names from a query like this:

$sql_query = "SELECT table1.*, table2.name FROM table1 LEFT JOIN table2 ON table1.table2_id = table2.id";

I need the columns names from the joined tables query, so the result have to be:

object[ column_name: "wahtever", (whatever columns table1 have)... column_name: "name" (this is the column selected from table2) ]



from Recent Questions - Stack Overflow https://ift.tt/3ji8N0G
https://ift.tt/eA8V8J

No comments:

Post a Comment