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.
| 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? |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-04-09 : 18:29:36
|
| Do you have a specific example? |
|
|
|
|
|
|
Article: Using Subqueries to Select Records