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

12 votes200 views2 answers
Find duplicates mysql column
SQL
1 vote130 views1 answer
Mysql select and count left join
SQL
1 vote111 views2 answers
Drop function in sql
SQL
0 vote109 views1 answer
How to to get current date and time in sql
SQL
0 vote115 views1 answer
Top frequency in sql server
SQL
0 vote168 views1 answer
MySQL update with subquery
SQL
2 votes106 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote112 views1 answer
Oracle query archive mode
SQL
0 vote106 views1 answer
How to get initials in sql
SQL
0 vote128 views1 answer
Window function to forward fill
SQL