/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 vote358 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
2 votes323 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote325 views1 answer
Mysql value ends with
SQL
1 vote335 views1 answer
How to put value in variable mysql
SQL
0 vote263 views1 answer
How to see the content of tables in pgadmin
SQL
6 votes313 views2 answers
How to copy data in sql
SQL
0 vote329 views1 answer
Sql with example
SQL
0 vote305 views1 answer
Oracle query archivemode
SQL
0 vote285 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote312 views2 answers
How to get the date from datetime in mysql
SQL