I have tow tables, that are slightly different because they cover tow
slightly different ways of accessing data - one is URLS and the other is
BLOB stored downloadable material - but I want to make them seamless in
user land so they click on something, and whether its coming out of the
database or being pulled off a remote site is not apparent.

Is there a single query that can take fields from two tables and merge
them under the same name and sort on that?

Like

select name.table_one and name.table_two as munged_name sort by munged_name

etc etc..

On 2010-11-20 01:59, The Natural Philosopher wrote:
Sounds like a union

select ... from T1
union
select ... from T2
order by ...


/Lennart

Lennart Jonsson wrote:
Ah..never used UNION. Right. with that handy word to hang the problem
on, I now know WHICH bit of the manual to read.

TVM