s****u
发帖数: 23 | 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*****g
发帖数: 34098 | 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****u
发帖数: 23 | 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
|
|
