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

0 vote355 views1 answer
Delete from table where length sql
SQL
0 vote393 views1 answer
Compress sql file database ubuntu
SQL
1 vote326 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote319 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote295 views1 answer
How to remove default in mysql
SQL
0 vote334 views1 answer
Postgresql check total storage
SQL
0 vote328 views1 answer
Closure in sql
SQL
3 votes298 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
10 votes313 views1 answer
Oracle all_dependencies
SQL
0 vote334 views1 answer
Postgres get database encoding
SQL