Category: Core Java

Some of the SQL basics.

SQL INNER JOIN Syntax : SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name; OR SELECT column_name(s) FROM table1 JOIN table2 ON table1.column_name=table2.column_name; — This is used to filter with the ids for the tables which have …