Usilng tables

[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.

 

[Guest]

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

 

[Spider]

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

 

[Marshall Barton]

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.

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.