SQL JOIN

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.
Tables in a database are often related to each other with keys.



SYNTAX :
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

database table 'persons'

u_key

fname

lname

location

10986GauravSahuUnnao
10987LalitGuptaKanpur
10988AnujChauhanLucknow
10989AnkitSinghBanaras

database table 'orders'

p_key

seiral_no

u_key

11333310987
22444410986
33555511111
44666610989



Online Execute/Compile