Help w/ Query

[eyal8r]

Hey guys-
I have 2 tables- and need to find the record matches between them via their product code. Table 1 has the code as follows (and is considered 'the Master List')-
xxx-xx-xxx Where x is an integer.

Table 2 has split the 3 sections of the code out to 3 individual fields, like this-
Field1 Field2 Field3
xxx xx xxx

I need a query that will combine the 3 fields in table 2 to the same format as Table1 so that I can find the matches between them. I know this is a basic question, but I'm a learning newbie. How would I write that in a query? I don't think I want to write the format to the table- just include it in the query somehow...
Thanks!

 

[PHV]

Perhaps something like this (SQL code) ?
SELECT *
FROM Table1, Table2
WHERE Table2.Field1 & '-' & Table2.Field2 & '-' & Table2.Field3 = Table1.[product code]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[eyal8r]

Thank you! Now- if I am going to find the MATCH in the 'master list (Table1), and take a field from Table1 of the matching records and insert it into a specific field in Table2- how do I do that?

ie-
Of the ones that match (as stated above), take Table1.Name and insert it into Table2.Name

Can you help?
Thanks!

 

[PHV]

Have a look here:

http://r937.com/relational.html