RE: Join Query

Tech-Archive recommends: Speed Up your PC by fixing your registry

Or you could do something like:

SELECT Table1.*, Table2.*
FROM Table1, Table2
WHERE mid(Table1.MemberID, 2) = Table2.MemberID

or:

Select Table1.*, Table2.*
FROM Table1
INNER JOIN Table2
ON mid(Table1.MemberID,2) = Table2.MemberID


--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



"Metcare" wrote:

I am trying to create a query from two tables that produces a result if the
(MemberID)field from table 1 matched the MemberID field in Table 2.
The first table came from another system (originally in excel) , and I
imported the file to access.
The memberID field in Table one has this text format H12345678 created
orignally in EXCEL, while the other table has the memberID field that was
populated using input masked in Access as H12345678. Access users in Table 2
only put the digits with the H automatically saved as part of the input
mask. So I believe the H is not really saved although I see it in the record.
My problem is , when I run my JOIN query based on the memberID, it is not
recognizing any matched records, even if we have several records that matched
since I think Table1 has the prefix H while Table2 does not actually have
the prefix H as when I query a memberID without the H , the record shows ,and
does not show when I query with H.
How do create a JOIN query to produce a list of records with matching
MemberID from table 1 and table 2.
Appreciate your help.
.

Relevant Pages

  • Re: Joining one to many relational table
    ... Since your table1 violates the first normalization, join query does not ... >> For Table1 the values for column1 is A,A,B,B,B and the correspoding ... >> In Table2 the values for column1 is A,B and the correspoding values in ...
    (microsoft.public.cert.exam.mcad)
  • Combine 2 tables in Access 2000
    ... Table1 has MemberID as the primary field. ... I want to add the fields from Table2 into either Table1 or ... want one table with all member information together ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Tricky Visual Basic Code help...
    ... moves the current record into a new record in table2. ... this with a little VBA code and a couple custom queries. ... Set a "pushFlag" column in the record in table1 to a specific ... If a duplicate is not found, ...
    (microsoft.public.access.formscoding)
  • Re: Help needed with importing XML
    ... You could add a gratuitous identity column to #temp and use ... Those examples showed how to decompose arbitrary XML in multiple ... table1 and table2. ... But there has to be something in the relational schema tying table1 ...
    (microsoft.public.sqlserver.xml)
  • Re: 2 column pulldown
    ... Allen Browne - Microsoft MVP. ... these field heading names come from Table2 since it is a lookup and so ... Table1 of course only has a single column name ... fieldX from Table1 is pulldown revealing candidate values of Table2. ...
    (microsoft.public.access.forms)