Please start any new threads on our new site at 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 

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.

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 -