Write a SQL statement to list P_CODE and P_DESCRIPT of all products along with their vendors' V_CODE
Fantastic news! We've Found the answer you've been seeking!
Question:
Write a SQL statement to list P_CODE and P_DESCRIPT of all products along with their vendors' V_CODE and V NAME if available. Note that your results must include all products regardless of whether vendor information is available or not. For products where vendor information is not available, V_CODE and V_NAME columns will be empty or NULL in the result (Hint: use outer join).
Related Book For
Accounting Information Systems
ISBN: 978-1260153156
2nd edition
Authors: Vernon Richardson, Chengyee Chang, Rod Smith
Posted Date: