Re: Joining and then ordering by a common column


MrKrinkle wrote:
> Hmm, it's interesting but I don't think I can make use of that output-
> I just get a list of ages without knowing what they correspond to. I
> tried adding the uid's of the tables, but the uid's merge together in
> the results, so you don't know whether it's a tableA uid or a tableB
> uid.

How about:

SELECT age, 'tableA' as source FROM age1
UNION
SELECT age, 'tableB' as source FROM age2
ORDER BY age


/Lennart

.

Relevant Pages

  • Re: Slate: The Legend of the Scope Trial
    ... >> error in knowing your own age? ... Supposedly a common ... > tactic in that area was to adopt the identity of an older person no ...
    (rec.arts.sf.fandom)
  • Re: Security measures?
    ... You have no way of knowing that - something else might well have killed him at that age, if he had NOT developed lung cancer! ... (LIFE is essentially a fatal disease - what actually causes one's departure is largely in the hands of fate.) ...
    (rec.travel.europe)
  • Re: Security measures?
    ... My reply was a comment upon your assertion that "He ... > him at that age, if he had NOT developed lung cancer! ... Not knowing how long one will live is hardly a reason to kill oneself ...
    (rec.travel.europe)
  • Re: Honorific Question: =?ISO-2022-JP?B?GyRCQzZGYSQ1JHMbKEI=?=
    ... Sean wrote: ... not knowing this term before; the first time she used it, ... Just wait until you have children, and somebody twice your age, who ...
    (sci.lang.japan)
  • Let me give you info...
    ... child. ... Believe me, I have no special interest in knowing this information, ... Just curious if andrews children are 3 years apart in age and maybe this ... I will say is that my kids are not three years apart. ...
    (alt.vacation.las-vegas)