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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 What kind of join do I need?

Author  Topic 

jampboo
Starting Member

0 Posts

Posted - 2000-08-15 : 00:00:00
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 tables a list of all of the VENDOR_NAME 's that have appeared in the INVOICE table. Is this possible?

Thanks
   

- Advertisement -