/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

10 votes208 views2 answers
Forgot my mysql password mac
SQL
0 vote200 views3 answers
Postgres trim string
SQL
0 vote219 views1 answer
Sql statement show all emails with dome
SQL
13 votes206 views2 answers
Sql join
SQL
-1 vote227 views2 answers
Sql truncate number
SQL
0 vote189 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote218 views1 answer
Oracle insert single quote in string
SQL
1 vote214 views1 answer
Oracle lowercase
SQL
1 vote205 views1 answer
Postgresql escape single quote
SQL
0 vote192 views1 answer
Oracle call a function in a insert statement
SQL