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 vote353 views2 answers
Mysql trim spaces
SQL
-1 vote333 views1 answer
Capitole toulouse
SQL
1 vote359 views1 answer
Sql server delete top 1000
SQL
0 vote339 views1 answer
Get current date data in mysql
SQL
-1 vote331 views1 answer
Extract Data from SQL Server into XML Format
SQL
24 votes316 views4 answers
Mssql get all table names
SQL
0 vote346 views1 answer
Difference between min and max date sql
SQL
1 vote371 views1 answer
Sql insert for each distinct value
SQL
0 vote325 views1 answer
Sql recherche nom prenom
SQL
0 vote318 views1 answer
Enable Rabbitmq management plugin
SQL