List:General Discussion« Previous MessageNext Message »
From:Kim Christensen Date:April 11 2006 10:56am
Subject:Re: A complex JOIN scenario
View as plain text  
On 4/11/06, Santino <mc5422@stripped> wrote:
> I do not try it :
>
> select invoice_id, order_id, customer_id, invoice_timestamp,
> invoice_total, null
> from invoice
> union all
> select invoice_id, null, null, null, null, invoice_journal_id
> from invoice_archive

Works like a charm, thanks!

--
Kim Christensen
kim.christensen@stripped
Thread
A complex JOIN scenarioKim Christensen11 Apr
  • Re: A complex JOIN scenarioMartijn Tonies11 Apr
    • Re: A complex JOIN scenarioKim Christensen11 Apr
  • Re: A complex JOIN scenarioMartijn Tonies11 Apr
    • Re: A complex JOIN scenarioKim Christensen11 Apr
  • Index merge optimization (with OR) and table joinsStuart Brooks11 Apr
    • Re: Index merge optimization (with OR) and table joinssheeri kritzer4 May
      • Re: Index merge optimization (with OR) and table joinssheeri kritzer4 May
  • Re: A complex JOIN scenarioMartijn Tonies11 Apr
    • Re: A complex JOIN scenarioKim Christensen11 Apr
  • Re: A complex JOIN scenarioSantino11 Apr
  • Re: Index merge optimization (with OR) and table joinsStuart Brooks23 May
Re: A complex JOIN scenarioKim Christensen11 Apr
  • Innodb import tuning on Sun T2000Russell Horn7 Jul