Re: [SLUG] [OT] Help needed with an SQL Join

[Tony Green <tgreen@xxxxxxxxxxxxxx>]

* This one time, at band camp, Paul Haddon said:
> You need two things:
> 
> 1) UNION
> 
> select TIME_STAMP, USERNAME, ACCTSESSIONID, OCCTSIN, OCCTSOUT
> from radius.accounting
> where TIME_STAMP between XXXX and XXXX 
> UNION
> select TIME_STAMP, USERNAME, ACCTSESSIONID, OCCTSIN, OCCTSOUT
> from radius2.accounting
> where TIME_STAMP between XXXX and XXXX
> order by TIME_STAMP

BAH!!!  MySQL doesn't have UNION.  However googling on union has given
me some how to simulate it (temp table after all).

Thanks for that

> 
> 
> 2) "SQL Queries for Mere Mortals" by Michael Hernandes & 
>    John Viescas. Addison Wesley

I will certainly look it up.

Greeno
-- 
Greeno <tgreen@xxxxxxxxxxxxxx>
GnuPG Key :  1024D/B5657C8B 
Key fingerprint = 9ED8 59CC C161 B857 462E  51E6 7DFB 465B B565 7C8B

Imagine working in a secure environment and finding the string 
_NSAKEY in the OS binaries without a good explanation
    -Alan Cox 04/05/2001