From: Date: April 23 2008 3:39pm
Subject: Re: Rewriting query to avoid inline view
List-Archive: http://lists.mysql.com/mysql/212463
Message-Id: <7E328E95-5F33-427E-8BED-92DAA8F23426@mac.com>
MIME-Version: 1.0 (Apple Message framework v919.2)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit


Thanks Rob and Baron, I'd never heard of the integers table approach  
before, really good stuff!

> First off your porting over or dealing with formerly oracle code,  
> right?

Nah, I just learned SQL on Oracle back in the day. DUAL works under  
MySQL also - don't know since what revision, but it works on 5.0.45 at  
least - but seeing that I don't need it, I'll stop using it, thanks  
for the tip!

Morten