List:General Discussion« Previous MessageNext Message »
From:Morten Primdahl Date:April 23 2008 3:39pm
Subject:Re: Rewriting query to avoid inline view
View as plain text  
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


Thread
Rewriting query to avoid inline viewMorten Primdahl23 Apr
  • Re: Rewriting query to avoid inline viewBaron Schwartz23 Apr
    • Re: Rewriting query to avoid inline viewSebastian Mendel23 Apr
      • Re: Rewriting query to avoid inline viewRob Wultsch23 Apr
  • Re: Rewriting query to avoid inline viewRob Wultsch23 Apr
    • Re: Rewriting query to avoid inline viewMorten Primdahl23 Apr
      • Re: Rewriting query to avoid inline viewRob Wultsch23 Apr
        • Re: Rewriting query to avoid inline viewRob Wultsch30 Apr