Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    40

    Unanswered: how to get query ? Please help

    i have 2 database table with SAME FORMAT but different information.
    for example,

    A database 2001 report table
    B database 2002 report table

    i want to get A(NAME) and B(NAME) by using query wizard function. but it say, u need to edit the relationship b4 u can proceed.

    how to solve it?

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select a.name
    from tableA
    UNION ALL
    select b.name
    from tableB
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jun 2004
    Posts
    40
    i am sorry, i am not very good at writing code. can u tell me simple things to get this done?

    Union code.

    i cant do it with wizard query function

  4. #4
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    You should not use the wizard function. Instead you can access the SQL text window through:
    Query => Design View => (Right Click) SQL View.
    Last edited by r123456; 07-19-04 at 22:57.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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