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 vote279 views1 answer
Count of tables in database mysql
SQL
8 votes284 views1 answer
Oracle all_source package body
SQL
0 vote299 views1 answer
QCompleter con sql
SQL
-1 vote323 views2 answers
Mysql get day of week
SQL
7 votes288 views6 answers
Group_concat mysql
SQL
0 vote279 views1 answer
How to avoid duplicate records in sqlite
SQL
21 votes287 views4 answers
Oracle add column
SQL
0 vote296 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote321 views2 answers
Coursera spark sql max count
SQL
1 vote281 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL