Syntax:
SELECT TABLE1.COLUMN1,TABLE1.COLUMN2,.......TABLE2.COLUMN1,TABLE2.COLUMN2,.....FROM TABLE1,TABLE2 WHERE TABLE1.COLUMN COLUMN = TABLE2.COMMON COLUMN
INNER JOIN
Inner Join selects the data from multiple tables based on the equality condition it means it selects only matched records from the multiple tables. For doing this Inner Join operation we should have to maintain one common valued column in the multiple tables.
Syntax:
SELECT TABLE1.COLUMN1,TABLE1.COLUMN2,.......TABLE2.COLUMN1,TABLE2.COLUMN2,.....FROM TABLE1,TABLE2 WHERE TABLE1.COLUMN COLUMN = TABLE2.COMMON COLUMN
Syntax:
SELECT TABLE1.COLUMN1,TABLE1.COLUMN2,.......TABLE2.COLUMN1,TABLE2.COLUMN2,.....FROM TABLE1,TABLE2 WHERE TABLE1.COLUMN COLUMN = TABLE2.COMMON COLUMN
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment