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

1 vote126 views1 answer
Mysql login console
SQL
13 votes121 views2 answers
Sql count distinct group by
SQL
1 vote115 views2 answers
Mysql order by date asc null last
SQL
2 votes121 views3 answers
Mysql list tables by size
SQL
0 vote112 views1 answer
How to get initials in sql
SQL
0 vote120 views1 answer
Sql shell psql cannot enter password
SQL
0 vote120 views1 answer
Replace null value within column mysql
SQL
-1 vote125 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote109 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote126 views4 answers
First max salary in sql
SQL