I have two tables, product and prod_report. I want my query to return a list of product names, IDs, and URLs. If there is an "admin" report for a product, I want it to return the values from that report. Otherwise, I want null values for the report fields.
This seems to me like it should be...