FULL or LEFT JOIN

The FULL / LEFT JOIN keyword returns all rows from the left table (table 1), even if there are no matches in the right table (table 2).

Table 1: adetails

Table 2: assignto

Query:

select adetails.*, assignto.*  
    from adetails FULL JOIN assignto  
    on adetails.machine_sno=assignto.machine_sno

    or

    select adetails.*, assignto.*  
    from adetails LEFT JOIN assignto  
    on adetails.machine_sno=assignto.machine_sno

Result: