Joining tables

S

Sharp

Hi

I have two tables A and B.
I would like to join them without any loss of information.
What type of join should I being using?
Does the defaulf 'join' allow for this?

cheers
michael
 
G

Guest

hi,
the "default" join is an inner join and no. an inner join
will omit records that have no match in either table.
i think you will need a union query to do what you want.
write a query that left joins table A to table B.
write a second query that left joins table B to table A.
union the the 2 queries.
post back if you need more assistance.
good luck
 
J

Jeff Boyce

Sharp

Joins don't "lose" information, they just connect tables. What do you mean
by "without ... loss of information"?
 
S

Sharp

Joins don't "lose" information, they just connect tables. What do you
mean
by "without ... loss of information"?
Click to expand...

There are several types of joins (inner-join, left-join, right-join, and
outer-join) for connecting two or more tables, and they all work
differently. I believe the outer-join will connect two tables without loss
of information.

Cheers
Michael
 
Top