Search code snippets, questions, articles...

INNER JOIN SQL Query

SELECT 
Column1 FROM tbl1,
Column2 From tbl1,
Column1 FROM tbl2
FROM 
table1 as tbl1
INNER JOIN 
table2 as tbl2
ON tbl1.column_tbl1 = tbl2.column_tbl2
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

To apply INNER JOIN on two tables we can use the above SQL query. It will show the rows from 'table1' and 'table2' which has common values for "column_tbl1" from "tbl1" and "column_tbl2" from "tbl2"

Was this helpful?
0 Comments