combining names

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JohnE (JohnE_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 14:25:05 -0800

I have 2 tables (tableA, tableB) that have names in them. I would like to
combine the name field from each table to create a full list of names coming
from both tables. I am at a loss on this. Seeking the advice of someone who
can get me started.
Thanks.
***John

Relevant Pages

  • Re: Samay -- Sum
    ... CREATE TABLE TableA ... totalAmount INT ... INSERT TableA SELECT 'john', 1 ... SELECT * FROM TableB ...
    (microsoft.public.sqlserver.server)
  • Re: Samay -- Sum
    ... select sum) from TableA a,TableB b ... > TableB Name, Address, Total Amount ... > Please advice me with my attached Query ...
    (microsoft.public.sqlserver.server)
  • Re: How do I subtract two different fields that r in different tables
    ... Let's say TableA has 23188 records. ... TableB has 9815 records. ... Your Forms reference has NOTHING to do with doing calculations between ... John W. Vinson ...
    (microsoft.public.access.gettingstarted)
  • Re: Cursors (again)
    ... What does it matter if TableB is temporary? ... or tableA. ... open cTableB ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL: Working with huge tables of chronological data
    ... TableB is ~30 millions row and contains (timestamp, ... from tableA TA1 left outer join tableB TB on (TA1.timestamp < ... that portion of the plan was executed. ...
    (comp.databases.oracle.server)