OBJECTIVE: To create a Result making duplicate value as zero in PO Amount
AVAILABLE TABLES:
PO Table
Suppliers Table
This is what my SQL query so far:
`
AVAILABLE TABLES:
PO Table
Suppliers Table
This is what my SQL query so far:
Code:
SELECT t1.*, t2.* FROM PO_Table t1 LEFT JOIN SI_Table t2 ONE t1.[PO Number] = t2.[PO Number]