/SQL/How to select multiple columns from different tables in mysql

How to select multiple columns from different tables in mysql

-- MySQL 
-- t1 = table1
-- dt2 = column of table
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

Source: stackoverflow.com

Similar codes

0 vote368 views1 answer
Rails sql query converstion
SQL
50 votes425 views6 answers
Sql duplicate rows
SQL
2 votes366 views2 answers
Storing timezones in postgres
SQL
4 votes321 views2 answers
How to count items with same name in sql
SQL
1 vote391 views1 answer
Oracle see column type
SQL
1 vote342 views1 answer
Oracle list data files
SQL
1 vote362 views2 answers
Get table column names sql laravel
SQL
0 vote342 views1 answer
Show create table in postgresql
SQL
0 vote344 views3 answers
Joins and views sql
SQL
0 vote362 views1 answer
Oracle service name view
SQL