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?"
Try using INNER JOIN with SELECT DISTINCT statement. It should select only single matched records. SELECT DISTINCT VENDOR.VENDORNAME FROM VENDOR INNER JOIN INVOICE ON VENDOR.VENDORNAME = INVOICE.VENDORNAME
Article: Using Subqueries to Select Records
Posted - 08/15/2000 : 20:49:19
