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

5 votes171 views3 answers
Show indexes mysql
SQL
24 votes148 views4 answers
Postgres remove database
SQL
2 votes176 views4 answers
List databases in sql server
SQL
0 vote173 views1 answer
Pgadmin save data greyed out
SQL
11 votes141 views5 answers
Laravel db facade
SQL
0 vote142 views1 answer
Create a table from one field of another table
SQL
0 vote144 views1 answer
How to see password mysql vestacp
SQL
2 votes155 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote145 views1 answer
Mysql timediff
SQL
1 vote134 views3 answers
Java.sql.sqlexception: access denied for user
SQL