/ Published in: SQL
(Grabs all info that matches both tables)
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT te.ecr_number FROM Tbl_Package tp JOIN tbl_ecr te ON te.ecp_id = tp.ecp_id WHERE Package_Number = 0