Inner Join Conundrum

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Aaron
    #1

    Inner Join Conundrum

    Hello,

    I hope sombody would be kind enough to help me with this problem

    I have 3 tables,

    -Customer Details
    -Customer Invoices
    -Invoice Items

    Customer details has a 1 to many relationship with Customer Invoices.
    and Customer Invoices has a 1 to many relationship with Invoice Items.

    The main purpose of this is for a user to generate invoices.

    I have obtained an example of a code that performs a mail merge to
    MSWORD from Access and it works fine, I need to change the SQL
    statement within the code to select a specifc set of records as you
    can see I will need the INNER JOIN FUNCTION can anyone point me to a
    knowledgebase article or something.

    Thanks

    Aaron
    Tags: None
    • Jack MacDonald
      #2
      Re: Inner Join Conundrum

      The easiest way to generate an SQL statement is Access is to create a
      new query. Add the appropriate tables and join them using the
      appropriate keyfields. Display the desired fields by dragging them to
      the query grid. This is standard Access fare.

      Next, display the resulting SQL statement that is behind the query:
      View > SQL View. You can copy-and-paste the SQL statement into your
      example code.



      On 4 Aug 2004 19:02:49 -0700, aaron@rapid-motion.co.uk (Aaron) wrote:
      [color=blue]
      >Hello,
      >
      >I hope sombody would be kind enough to help me with this problem
      >
      >I have 3 tables,
      >
      >-Customer Details
      >-Customer Invoices
      >-Invoice Items
      >
      >Customer details has a 1 to many relationship with Customer Invoices.
      >and Customer Invoices has a 1 to many relationship with Invoice Items.
      >
      >The main purpose of this is for a user to generate invoices.
      >
      >I have obtained an example of a code that performs a mail merge to
      >MSWORD from Access and it works fine, I need to change the SQL
      >statement within the code to select a specifc set of records as you
      >can see I will need the INNER JOIN FUNCTION can anyone point me to a
      >knowledgebas e article or something.
      >
      >Thanks
      >
      >Aaron[/color]


      *************** *******
      jackmacMACdonal d@telusTELUS.ne t
      remove uppercase letters for true email
      http://www.geocities.com/jacksonmacd/ for info on MS Access security

        Comment

        Previous template Next
        Working...