Join two tables on multiple columns

[#1]

Hi All,

Can any one explain how to join two tables on multiple join conditions.

I have two table with 3 common fields. I need these fields in report. i don't want to concatenate these fields. If concatenate how get back these fields.

Thanks.

[oeobiora]

Could you help me re-create the equivalent of this statement in a load script?

It's from an access query.

SELECT

part_characteristics.ATA_location,

part_characteristics.engine_configuration_seq,

part_characteristics.part_nomenclature,

part_ata_lookup.part_number,

engines.engine_configuration_seq,

engines.engine_serial

events.event_seq,

events.event_date

events.vdata_db_id

FROM ((part_characteristics INNER JOIN part_ata_lookup ON (part_characteristics.ATA_location = part_ata_lookup.ATA_location) AND (part_characteristics.engine_configuration_seq = part_ata_lookup.engine_config_seq)) INNER JOIN (debit_doc_line_items INNER JOIN debit_docs ON debit_doc_line_items.debit_doc_seq = debit_docs.debit_doc_seq) ON (part_ata_lookup.ATA_location = debit_doc_line_items.ATA_location_code) AND (part_ata_lookup.engine_config_seq = debit_doc_line_items.engine_configuration_seq)) INNER JOIN (((vendor_job_number INNER JOIN debit_doc_applications ON vendor_job_number.vendor_job_number_seq = debit_doc_applications.vendor_job_number_seq)INNER JOIN events ON vendor_job_number.event_seq = events.event_seq) INNER JOIN engines ON events.engine_seq = engines.engine_seq) ON debit_docs.debit_doc_seq = debit_doc_applications.debit_doc_seq;