Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Using Subqueries to Select Records

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-15 : 20:49:19
John writes "Okay, here's my problem. I have these two tables: INVOICE, which includes everything about a particular invoice including a vendor_id. The second table is VENDOR, which includes the vendor name for each vendor_id. What I want to be able to do is select from the VENDOR table a list of all of the vendor_names that have appeared in the INVOICE table (even if they have appeared in the INVOICE table many times, I just want them to show up once). Is this possible?"

Article Link.

cducker
Starting Member

1 Post

Posted - 2002-04-09 : 17:15:51
Has anyone ever noticed a performance decline when the results of the nested query in the IN statement returns 100s of results?

Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-04-09 : 18:29:36
Do you have a specific example?


Go to Top of Page
   

- Advertisement -