/SQL/How to select multiple columns from different tables in mysql

How to select multiple columns from different tables in mysql

-- MySQL 
-- t1 = table1
-- dt2 = column of table
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

Source: stackoverflow.com

Similar codes

0 vote195 views1 answer
Mariadb disable foreign key checks
SQL
22 votes158 views4 answers
Mysql date_format
SQL
0 vote146 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote184 views1 answer
Sql convert unix time to date
SQL
0 vote153 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
8 votes170 views1 answer
Check mysql version phpmyadmin
SQL
2 votes161 views1 answer
Pandas to sql index
SQL
-1 vote152 views2 answers
How to display top 50 rows?
SQL
10 votes160 views2 answers
Mysql drop database if exists
SQL
0 vote145 views1 answer
Mysql calculated column
SQL