Top 1 of a join 1

[nowandever29]

I have a database that has a central table called applications, joined in a many to many relationship with three other tables, contacts, vendors, and servers. I.E., an application can be installed on multiple servers, or multiple applications can be installed on one server. The same goes for the other tables.

I have a view that joins the tables with LEFT OUTER JOIN. As expected, when there are multiple contacts, say, for one application, I get multiple rows for that application, each showing a different contact.

I need to do a different view, showing only one row for each application, and say the first contact, server and vendor it finds. How would I do this, with a TOP 1 statement? A left INNER join? Please help...

 

[markros]

Please see

http://blogs.lessthandot.com/index....rver/including-an-aggregated-column-s-related

for different ways of getting your results.

Come back if you would still have questions.