Posted by Chicagoboy27 on 10/17/06 15:30

I have a table. In the table I have different types of mailing
addresses. The addresses are linked by and ID. ex,

addresses per ID 1
ID address
1 add2
1 add3
1 add4

distinct Addresses in table
ID address
1 add2
1 add3
1 add4

What I am trying to figure out is if this is possible. Is it possible
to figure out some how with a query that in the above example ID 1
is missing add1. I am trying to populate a dropdown list in my code
with just the addresses that are left from the distinct list. I tried
doing an intersect something like this but that did not seem to work.

SELECT type
FROM address_demo
INTERSECT
SELECT type
FROM address_demo AS address_demo_1
WHERE progid = '12954892'

I am wondering if I am moving in the right direction or if this is even
possible......

Thanks

• Next in forum: Re: SQL Query return unused values
• Prev in forum: Re: Execute an schedule job from MSDE with LINKED servers in SQL Server
• Thread view: SQL Query return unused values

[Reply to this message]