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

2 votes408 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote398 views2 answers
Sql insert timestamp
SQL
0 vote349 views1 answer
Mysql select all where count more than"
SQL
4 votes312 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote359 views1 answer
Create or replace view postgress
SQL
0 vote381 views1 answer
Logtash mysql cofiguration file
SQL
0 vote373 views1 answer
Mysqli_connect using prepare statement
SQL
-1 vote380 views5 answers
Operator in sql
SQL
2 votes363 views1 answer
Change primary key sql
SQL
6 votes417 views3 answers
Check if string contains substring sql
SQL