I am new in Mysql. I have multiple tables and i want to join all of them. I use INNER JOIN for this.
"SELECT *
FROM table
INNER JOIN table2
ON table.client_id = table2.id
WHERE table2.id= 113
ORDER BY table.id DESC
LIMIT 1 ";
Here i face a problem that i have a column name title in each table. I want to use AS in my command. Like in outlook table there is name of column is TITLE i want to use it as outlook_title. How it is possible?
I want to use echo to print data like this
echo '<h1>' .$row["client"]. '</h1>' ;
echo '<h1>' .$row["name"]. '</h1>' ;
echo '<h1>' .$row["name"]. '</h1>' ;
echo '<h1>' .$row["ation_title"]. '</h1>' ;
echo '<h1>' .$row["look_title"]. '</h1>' ;
Please help me