Joining tables

[Anonymous]

Hi All

Stuck on a school boy error!

I need to join a field to a facts table so it links to my table for example.

Table A contains

Car

Reg_No

Colour

Table B Contains

Price

Location

Engine Size

How can i add price to Table A ?

Or how can i link these 2 together without a connecting key?

Thanks

[alexandros17]

I answer with an example:

Car  Reg_No Colour

Ford 111 Red

Citroen 222 White

Price Location Engine Size

1000     France   150

1500     Italy         90

the resulting join will be:

Ford 111 Red     1000     France   150

Ford 111 Red     1500     Italy         90

Citroen 222 White     1000     France   150

Citroen 222 White     1500     Italy         90

And this will not help you ... you need a link between the 2 tables

Hope it helps