Joining tables

  • Thread starter Thread starter Sharp
  • Start date Start date
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
 
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
 
Sharp

Joins don't "lose" information, they just connect tables. What do you mean
by "without ... loss of information"?
 
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
 
Back
Top