/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

54 votes349 views6 answers
Sql rename column
SQL
0 vote275 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote215 views2 answers
Nosqlbooster query other collection
SQL
53 votes413 views6 answers
How to install mysql ubuntu
SQL
0 vote243 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote231 views1 answer
Sql remove last 2 digit
SQL
0 vote195 views1 answer
Month mysql
SQL
2 votes253 views3 answers
Postgres json to string
SQL
0 vote279 views1 answer
Sql check if field is not null
SQL
2 votes218 views4 answers
Mysql select into new table
SQL