I have 3 tables:

Import_accomodation:
- several attributes.....
- continentname
- regionname

Continent:
- ContinentId (PK)
- ContinentName

Country:
- CountryId (PK)
- ContinentId (FK, can be null)
- CountryName

The import_accomodation table is a flat table from which I want to transfer
data into the continent and country tables. Of course these are related. I
don't know which query to use for this. To fill continent I use:
insert into continent select continentname from import_accomodation where
continentname != '' and continentname not in (select name from continent)
But to fill country I don't know how to create a query to get the optional
relation.
Thanks a lot.
--
John

Hello John5771,


Country you are looking to join Import_Accomodation to Continent where the
join attribute is ContinentName(LEFT OUTER JOIN). From this you will retrieve
the PK from ContinentID



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Great, Allan, that solved my problem.

Thanks