Sunday, December 14, 2014

#6. Write a SELECT statement that returns these two columns: CategoryName The CategoryName column from the Categories table ProductID The ProductID column from the Products table



#6.  Write a SELECT statement that returns these two columns: 
CategoryName The CategoryName column from the Categories table
ProductID The ProductID column from the Products table
Return one row for each category that has never been used. Hint: Use an outer join and only return rows where the ProductID column contains a null value.

Posted by at

1 comment:

  1. UnknownFebruary 27, 2016 at 5:12 PM

    thank you for the help, really appreciate it. Do not like the popups though! That makes me think there is a virus so I turned off all popups and now your site works great. Again thank you for the help!!

    ReplyDelete

Subscribe to: Post Comments (Atom)