Oracle INNER JOIN

SELECT columns
FROM table1 
INNER JOIN table2
ON table1.column = table2.column; 

SELECT suppliers.supplier_id, suppliers.supplier_name, order1.order_number
FROM suppliers 
INNER JOIN order1
ON suppliers.supplier_id = order1.supplier_id;