Re: Match Query

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 07/02/04

  • Next message: Julien Sahuc: "Re: consuming a web service without IIS" 
    Date: Fri, 2 Jul 2021 07:28:13 -0400

    Assuming you're creating the query through the QBE query builder, drag both
    fields from table1 to table2 so that there are 2 lines between the tables.

    The SQL will look something like:

    SELECT Table1.Field1, Table2.Field2, Table3, Field3...
    FROM Table1
    INNER JOIN Table2
    ON (Table1.[Last Name] = Table2.[Last Name] AND Table1.[Item#] =
    Table2.[Item#]) 

    -- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Barb St. Clair" <barbstc@comcast.net> wrote in message
news:ZR4Fc.10834$wY5.4880@attbi_s54...
> I have two tables (related) and I want a query that will show records when
> two fields match from each table, two from table one, two from table two.
> Table1                    Table2
> Last Name            Last Name
> Item#                    Item#
>
>   Any suggestions?
>
> -- 
> -Barb
> barbstc@comcast.net
>
>
>
  • Next message: Julien Sahuc: "Re: consuming a web service without IIS"