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

16 votes259 views2 answers
Mysql date between two dates
SQL
2 votes258 views1 answer
Metasploit start postgresql
SQL
2 votes238 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote234 views1 answer
Storing RGBA in mysql db
SQL
6 votes244 views2 answers
Non relational database
SQL
0 vote274 views1 answer
How to check rollback status in oracle
SQL
0 vote230 views2 answers
Sql server select first day of previous year
SQL
0 vote258 views2 answers
Sql auto update dupdated_at
SQL
0 vote196 views0 answer
SQL
17 votes256 views4 answers
Postgres list users
SQL