> table a has ak1 and ak2 as primary key
> table b has bk1 and bk2 as primary key
> how do I join these tables?
>
> if i write
> where a.ak1 = b.bk1 and a.ak2 = b.bk2
> data are returned multiple times.
AnneMarie,
When you say "data are returned multiple times" please clarify what you mean:
a)
> table a has ak1 and ak2 as primary key
> table b has bk1 and bk2 as primary key
> how do I join these tables?
>
> if i write
> where a.ak1 = b.bk1 and a.ak2 = b.bk2
> data are returned multiple times.
AnneMarie,
When you say "data are returned multiple times" please clarify what you mean:
a)
[EMAIL PROTECTED] schrieb am Freitag, 24. August 2001, 13:43:15:
> table a has ak1 and ak2 as primary key
> table b has bk1 and bk2 as primary key
> how do I join these tables?
> if i write
> where a.ak1 = b.bk1 and a.ak2 = b.bk2
> data are returned multiple times.
Well this should be. You sho
table a has ak1 and ak2 as primary key
table b has bk1 and bk2 as primary key
how do I join these tables?
if i write
where a.ak1 = b.bk1 and a.ak2 = b.bk2
data are returned multiple times.
/AM
-
Before posting, please check:
