Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    62

    Unanswered: unmatched fields for a union query?

    Hi,
    I have two queries which I would like to put into a report. I initially thought a union query would be the way to go but the queries to not have matching fields. Is there another way to do this?
    thanks
    Sue

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    You can solve this by,

    Select ta.a, ta.b, ta.c, ta.d
    from tableA ta
    UNION
    select tb.a, tb.b, 'NA', 'NA'
    from tableB tb
    Last edited by r123456; 07-15-04 at 10:29.
    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
    Apr 2004
    Posts
    62

    thanks

    Thank you once again but I just used subreports instead - seemed to do the trick!

Posting Permissions

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