can we fetch common records from two tables?

Answer

The below statement could be used to get data from multiple tables, so, we need to use join to get data from multiple tables.

Syntax :

SELECT tablename1.colunmname, tablename2.columnname    
FROM tablename1  
JOIN tablename2  
ON tablename1.colunmname = tablename2.columname
ORDER BY columnname;