Many to Many Relationship with Tables

[aaleem]

I have 4 tables that were not initially designed to be joined. The
primary key is different for each table. Can these tables be joined in
a many to many relationship?

[Gary Floam]

Could be, but many-to-many relationships are tricky, as you are working with a
Cartesian product, and you will usually get much more than you want. It's
hard to guess what you are trying to do, but I would suggest looking at the
Union Query.

Hope this helps a little.

Gary

<aa****@att.comwrote in message
news:11**********************@n2g2000hse.googlegro ups.com...

>I have 4 tables that were not initially designed to be joined. The
primary key is different for each table. Can these tables be joined in
a many to many relationship?