/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

2 votes179 views1 answer
Mysql increment value by 1 in update
SQL
2 votes138 views1 answer
Sql float to int
SQL
1 vote422 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote205 views1 answer
How to delay stored procedure execution in sql server
SQL
5 votes225 views2 answers
Mysql where in array
SQL
0 vote272 views1 answer
Show mysql account privilleges
SQL
0 vote220 views1 answer
Like and not like together in sql
SQL
13 votes254 views4 answers
Mysql remove foreign key constraint
SQL
1 vote191 views1 answer
Mysql dump specific tables
SQL
0 vote232 views1 answer
Mariadb disable foreign key checks
SQL