/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 vote203 views1 answer
How to to get current date in sql
SQL
0 vote193 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote255 views2 answers
Sqlalchemy default value for column
SQL
0 vote211 views1 answer
Mysql zerofill
SQL
0 vote207 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
4 votes221 views2 answers
Mysql delete user if exists
SQL
13 votes224 views2 answers
Sql online compiler
SQL
1 vote208 views2 answers
Mssql show database size
SQL
0 vote182 views1 answer
Online sql compiler
SQL
0 vote197 views1 answer
Insert set mysql
SQL