MySQL

What is a join In a real world application, data resides in multiple tables and often you need to fetch data from multiple tables in order to display meaningful information. Example, suppose there are two tables Employee: containing basic information about an employee such as his role, designation, department, managerid etc. Employee_Detail: containing personal information of an employee such as his name, address, blood group, phone number etc. Rows of both the tables are linked by a column employeeid in the second table which also happens to be the foreign key in the Employee_Detail table referencing the Employee table. Now when it is required to displayRead More →