Inner Join

What is Inner Join?

Inner Join is a join of two or more tables that returns only the rows that satisfies the join condition.

What is Syntax of Inner Join Queries?

1. select * from a INNER JOIN b on a.a = b.b;

2. select a.*,b.* from a,b where a.a = b.b;