union with order by

Article View: borland.public.interbase.sql

Article #615

Back to borland.public.interbase.sql Previous Next

#615

From: John Hart
Date: Wed, 29 Aug 2007 02:53

15 lines
1337 bytes

Hi, I want to merge two or more tables and order them but I can't seem to 
get it to work, below is a simplified sql that I tried after my original one 
failed.

select name, created
  from TWSUPPLIER
union
select name, created
  from TWCUSTOMER
union
select mydesc as name, created
  from TWPRODUCT
order by created

Thank you

Technical Details

Message-ID: <46d4dfbd$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,2606ab9c57d082e6,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "John Hart" <twsjohn@optusnet.com.au>
Newsgroups: borland.public.interbase.sql
Subject: union with order by
Date: Wed, 29 Aug 2007 12:53:48 +1000
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-Antivirus: avast! (VPS 000769-1, 28/08/2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 58.110.127.73
Message-ID: <46d4dfbd$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1188356029 58.110.127.73 (28 Aug 2007 19:53:49 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1178