Access question. Pls help.Thx - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Access question. Pls help.Thx

Access question. Pls help.Thx# Database - 数据库

s*u2007-11-15 08:11

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.

B*g2007-11-15 08:11

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.

s*u2007-11-15 08:11

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