/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 vote355 views1 answer
Postgresql regular expression special characters
SQL
0 vote342 views2 answers
Sql drop view if exists
SQL
0 vote385 views1 answer
Sql delete caracter list
SQL
0 vote330 views1 answer
Duplicate foreign key constraint name
SQL
3 votes353 views1 answer
How to uninstall microsoft sql server
SQL
0 vote375 views1 answer
View t-sql mail configuration
SQL
0 vote390 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote346 views1 answer
If null don't update
SQL
2 votes372 views1 answer
Mysql clear screen
SQL
1 vote339 views1 answer
Sql week commencing date
SQL