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 vote268 views2 answers
Mysql filter by date mount
SQL
1 vote266 views1 answer
Delete specific row in sql
SQL
3 votes276 views2 answers
How to delete git repo locally
SQL
1 vote263 views2 answers
Restart identity cascade
SQL
2 votes261 views1 answer
Plsql block
SQL
0 vote316 views1 answer
Hierarchal database table
SQL
3 votes267 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote253 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote313 views3 answers
Postgres trim string
SQL
4 votes276 views4 answers
Pl sql output
SQL