/SQL/Join

Join

SELECT column-names
  FROM table-name1 
  JOIN table-name2 ON column-name1 = column-name2
 WHERE condition

Source: dofactory.com

Join

mysql> SELECT a.id, a.name,b.id FROM tutorials_inf a,tutorials_bks b WHERE a.id = b.id;
+----+-------+----+
| id | name  | id |
+----+-------+----+
|  1 | sai   |  1 |
|  2 | johar |  2 |
|  3 | raghu |  3 |
|  4 | ram   |  4 |
+----+-------+----+
4 rows in set (0.00 sec)
mysql>

Source: tutorialspoint.com

Join

select * 
from   toys
join   bricks
on toy_id > brick_id ;

Source: livesql.oracle.com

Similar codes

0 vote114 views1 answer
How to query all tables mysql at the same time
SQL
0 vote115 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
3 votes112 views2 answers
Create schema postgres
SQL
37 votes107 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote105 views1 answer
Sqlite update only if greater
SQL
1 vote111 views1 answer
Wordpress change http to https phpmyadmin
SQL
2 votes103 views1 answer
How to add where command in update comand with joins
SQL
0 vote108 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote104 views1 answer
Postgresql interview questions
SQL
2 votes106 views1 answer
Oracle find constraints referencing a table
SQL