Left and right join of tables in oracle
Select tp.technic_product_code
Tp.technic_product_name
Mp.marketproduct_code
Mp.marketproduct_name
From marketproduct_info mp, technic_product_info tp
Where mp.id_technic_product_info = tp.id_technic_product_info (+)
1) + is written on that table, indicating that the table is allowed to be empty
+ written on the right, indicating the left connection, dominated by the left table
+ written on the left, indicating the right connection, dominated by the right table
