Results 1 to 2 of 2

Thread: Query Help

  1. #1
    Join Date
    Jul 2004
    Posts
    7

    Unanswered: Query Help

    Hi, I need help with Access.
    I have 6 tables consisting of transactions and 1 table with customer info. The transaction tables have a common ID(Primary Key) with the customer table.

    The tables are:
    Customer
    Jan
    Feb
    Mar
    Apr
    May
    Jun

    How do I set up a query to show :

    Customer Jan Feb Mar Apr May Jun

    The customer may not have transactions in all the tables. eg. customer has transactions in only Jan Feb Mar.

    Thanks.

    Michael

  2. #2
    Join Date
    Oct 2004
    Posts
    105
    Hi Michael
    im not exactely good with sql im afraid but maybe something like that?
    SELECT customer.*, jan.*, feb.*, march.*, apr.*, may.*
    FROM ((((customer INNER JOIN jan ON customer.id = jan.id) INNER JOIN feb ON customer.id = feb.id) INNER JOIN march ON customer.id = march.id) INNER JOIN apr ON customer.id = apr.id) INNER JOIN may ON customer.id = may.id;
    hope it helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •