> Frankly, I don't understand why you would ever need such a beast, and I
> probably don't want to know (I suspect it will give me nightmares). In
> any case, assuming you really have a reason for this monster, try
> something like this:
Yeah, I need it, and the query that I auto-genera
TW <[EMAIL PROTECTED]> wrote:
> It would look like this:
>
> FName LName Side Height
> --
> Igor Tande A 1
> Telly Will B 1
> John Smith A 1
> Bob Hope B 1
> Sandy Rivera A 2
> Bobby Sangria B 2
> Jane Tane A 2
> Tom Jones B 2
>
> SELECT Fname, Lname, Side, Height FROM (
> Order is never guaranteed in a SQL statement's resultset, unless this
> statement specifies an ORDER BY clause. If some statement without such a
> clause happens to give you an order you want, it does so by accident. If
> you want a particular order, say so in the statement.
Yeah, whi
"TW" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I have been doing a Union query and would like to obtain distinct
> results.
> Via the manual, the correct way to accomplish this is to do a UNION
> statement (versus
> doing a UNION ALL).
>
> Problem: I want the order of the select
Hi,
I have been doing a Union query and would like to obtain distinct
results.
Via the manual, the correct way to accomplish this is to do a UNION statement
(versus
doing a UNION ALL).
Problem: I want the order of the select statements left intact after
the UNION
select state
5 matches
Mail list logo
