How can I pull matching records without a primary key 2

[SeeWard]

How could one query two tables that may contain matching without a linked field *primary key*?
TIA

 

[lespaul]

join the query on the matching fields.

HTH

Leslie

 

[SeeWard]

Could be kind enough to show an example? I am uncertain how to do that...Thank you for your help...

 

[lespaul]

want to tell me about the two tables you're trying to get information from? What information do you want to get from them?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[fredericofonseca]

search these forums for select and join and you will find plenty of examples.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[SeeWard]

Thank you both so much. The info really helped out. I started poking around prior to Leslie's response and found that the Join works similarly to a MATCH statement...all that falls outside the match is discarded. But tell me this if you would please...will SQL then automatically create a new table with the resulting recordset?

 

[PHV]

Take a look at maketable query:
SELECT field list INTO newTable FROM ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886