MySQL: select records from multiple records

• Full join(Cross Join):
  

  SELECT employee.id, employee.name, salary.amount FROM employee, salary WHERE employee.id=salary.employee_id;
  

• Left/Right join:
  

  SELECT employee.id, employee.name, salary.amount LEFT JOIN ON employee.id=salary.employee_id;
  

SEE ALSO

• Retrieve records from multiple tables