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

5 votes185 views4 answers
Mysql on duplicate key update
SQL
0 vote172 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote186 views1 answer
Mariadb cast to int
SQL
24 votes192 views4 answers
Mysql datetime
SQL
3 votes176 views2 answers
Create schema postgres
SQL
10 votes192 views2 answers
Doublon sql
SQL
2 votes139 views1 answer
Sql view column data type
SQL
0 vote171 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote210 views1 answer
Nvl postgres
SQL
2 votes179 views1 answer
Mysql application.properties spring boot
SQL