Database 1421. NPV Queries ¶ SQL 1 2 3 4 5 6 7SELECT Queries.id, Queries.year, IFNULL(NPV.npv, 0) AS npv FROM Queries LEFT JOIN NPV USING (id, year); Was this page helpful? Thanks for your feedback! Thanks for your feedback! Help us improve this page by using our feedback form.