Select multiple tables mysql

SELECT t1.dt2, t2.dt4, t2.dt5, t2.dt3 #get dt3 data from table2
FROM table1 t1, table2 t2 -- Doesn't need to have t1, or t2
WHERE t1.dt2 = 'asd' AND t2.dt4 = 'qax' AND t2.dt5 = 456

How to select multiple columns from different tables in mysql

-- MySQL -- t1 = table1-- dt2 = column of tableSELECT t1.dt2, t2.dt4, t2.dt5, t2.dt3 #get dt3 data from table2
FROM table1 t1, table2 t2 -- Doesn't need to have t1, or t2
WHERE t1.dt2 = 'asd' AND t2.dt4 = 'qax' AND t2.dt5 = 456

Source: stackoverflow.com

Similar codes

0 vote150 views1 answer
Netstat -tln mysql
SQL
1 vote109 views1 answer
Database run
SQL
0 vote155 views1 answer
Mysql beautifier terminla
SQL
0 vote142 views2 answers
Update information in a mysql column
SQL
0 vote183 views1 answer
Sql get latest of 2 datetimes
SQL
1 vote148 views3 answers
Execute sp in sql server
SQL
6 votes158 views3 answers
Commit in sql
SQL
0 vote151 views1 answer
How to import sqlite driver class in java using maven
SQL
-1 vote137 views3 answers
Mysql get age from date
SQL
7 votes157 views1 answer
Sql server management studio turn on line numbers
SQL