|
-
Sep 30th, 2008, 10:03 PM
#1
Thread Starter
Fanatic Member
[RESOLVED] [Access SQL] Pull only 1 record per account from Customer.
How would I create a query, that pulls only 1 customer name from the customer table per account?
Tables
AccountTable
AccountNumber (PK)
Address
OtherInfo, etc...
CustomerTable
AccountNumber
FullName
If I do a left, inner, or right join, it will still get the incorrect number of records.
For instance.
Account table has 2 accounts.
1, 123 main street
2, 443 apple ave
Customer has 3 names
1, John
1, Jane
2, Bob
The returned results would be
1, 123 main street, John
1, 123 main street, Jane
2, 443 apple ave, Bob
How do I make it pick only 1 customer name, so that I am not duplicating address information?
Please RATE posts, click the RATE button to the left under the Users Name.
Once your thread has been answered, Please use the Thread Tools and select RESOLVED so everyone knows your question has been answered.
"As I look past the light, I see the world I wished tonight, never the less, sleep has come, and death shall soon follow..." © 1998 Jeremy J Swartwood
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|