Basic Query Question

• monquatch

  Old Hand

  Points: 364

  More actions

  April 12, 2004 at 11:59 am

  #359418

  Hi, SQL newbie here,

  I have two tables (TABLE1, TABLE2) with identical column structures. Each has colA, colB, colC, etc...

  All I'm trying to do is query certain fields (colA, colB) from both tables simultaneously and work with the resuting values but I'm having a difficult time of it.

  Is this possible?

  TIA,

• monquatch

  Old Hand

  Points: 364

  More actions

  April 12, 2004 at 12:25 pm

  #502452

  Hi,

  OK I figured this out by using the UNION operator.

  Thanks again!