Multiple Joins and Subqueries in SQL 2008 Server Manager Studio

[kevinpeterkin]

. Provide a list of productid’s, the name of the vendor and their credit rating. The results should be ordered by last name and then by credit rating. Write out the SQL that would accomplish this.

[Rabbit]

There's no way we can help without knowing the database structure. We would also need to see the SQL you tried and the problems you're having with it.