/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

6 votes199 views5 answers
Mysql get last insert id
SQL
0 vote202 views1 answer
Ms sql unique
SQL
0 vote241 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote201 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote215 views1 answer
Search db for table name
SQL
11 votes197 views3 answers
Sqlite3 create table from another table
SQL
0 vote231 views1 answer
Returning with sqlalchemy
SQL
0 vote231 views1 answer
Sql file in postgres with pgadmin
SQL
3 votes207 views2 answers
How to load files in mysql
SQL
2 votes202 views1 answer
Possgress drop if exists table
SQL