JOIN or INNER JOIN

INNER JOIN is the same as JOIN.

The INNER JOIN keyword return rows when there is at least one match in both tables.

Table 1: adetails

adetails

Table 2:  Orders

Query:

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

    or
    select adetails.*, assignto.*
    from adetails INNER JOIN assignto 
    on adetails.machine_sno=assignto.machine_sno

Result: