Usilng tables

S

Spider

What do I do if I want to join two or more tables with an inner join, but I
don't necessarily want to enter a value in one (or more) of the primary keys
in one of those tables? I don't always have data to be entered in some of
the related tables.
 
K

KARL DEWEY

You join queries not tables.
Tables have relations --
One-to-one
One-to-many
Many-to-many
 
S

Spider

Ok...same question, but using a query. There is a query involved that uses
all underlying tables.
 
M

Marshall Barton

Spider said:
What do I do if I want to join two or more tables with an inner join, but I
don't necessarily want to enter a value in one (or more) of the primary keys
in one of those tables? I don't always have data to be entered in some of
the related tables.
Click to expand...


Why do you need to use an inner join when you describe an
outer join?

Maybe an example set of data would help explain the issue
you're trying to deal with.
 
Top