Redian新闻
>
Access question. Pls help.Thx
avatar
Access question. Pls help.Thx# Database - 数据库
s*u
1
I have two tables. One is a list of SSN with Sept principal balance, the
other one is a list of the same SSN with Oct principal balance. The SSN is
not unique. Now I want to create a query with the same list of SSN and with
both Sept and Oct principal balance in one query. But I got duplicated
values. Like I for the same SSN and principal balance, I have two showing in
my query instead one. How can I get it fixed? Thanks for your kind help.
avatar
B*g
2
把你的sql贴出来

with
in

【在 s****u 的大作中提到】
: I have two tables. One is a list of SSN with Sept principal balance, the
: other one is a list of the same SSN with Oct principal balance. The SSN is
: not unique. Now I want to create a query with the same list of SSN and with
: both Sept and Oct principal balance in one query. But I got duplicated
: values. Like I for the same SSN and principal balance, I have two showing in
: my query instead one. How can I get it fixed? Thanks for your kind help.

avatar
s*u
3
Thank you. I figured it out. I missed a field. Adding this field, I can make
the borrower unique.:)

【在 B*****g 的大作中提到】
: 把你的sql贴出来
:
: with
: in

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。