Pulling from Two Tables

Results 1 to 2 of 2

Thread: Pulling from Two Tables

  1. #1
    Join Date
    Dec 1969

    Default Pulling from Two Tables

    ARGH! I used to know how to do this but have forgotten.<BR><BR>I have two tables with the exact same info in it. I am trying to pull from both tables at the same time. I think I did this with an inner join but I have lost the code.<BR><BR>Any thoughts?

  2. #2
    Join Date
    Dec 1969

    Default UNION

    SELECT fld1, fld2 FROM table1<BR>UNION<BR>SELECT fldA, fldB FROM table2<BR>ORDER BY 1, 2<BR><BR>

Posting Permissions

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