Combine data

[DSM1957]

I have not used accees in a few years, have forgotten the simplest of operations.

I am trying to set up a query to combine information from 3-4 tables. The common field element in each one is Part Number. Table 1 has all relevant part numbers listed (approximately 12,500). Tables 2,3, and 4 have additional data about some of the part numbers, each table has different data. There should be no duplicate part numbers in tables 2, 3, and 4. The query should include all fields from all of the tables.

Thanks for your help.

[recyan]

Check out key-word LEFT JOIN.

Thanks