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

2 votes292 views2 answers
Exec procedure pl sql
SQL
27 votes305 views4 answers
Get all tables with column name sql
SQL
2 votes308 views1 answer
How to find constraints on a table in oracle
SQL
0 vote301 views3 answers
Insert or ignore postgres
SQL
0 vote317 views1 answer
Sql server list table sizes
SQL
0 vote305 views1 answer
Oracle sql drop table
SQL
3 votes311 views3 answers
How to add month in update sql
SQL
0 vote307 views1 answer
Mac os zsh: command not found: mysql
SQL
18 votes283 views4 answers
Foreign key mySql
SQL
0 vote309 views1 answer
Case insensitive sql
SQL