Re: sql question

Tried. Also over 3 minutes.

Left join uses more time than a cartesian product, over 6 minutes. I killed the query.

--
iTech Consulting Services Limited
Expert in ePOS (Point-Of-Sales) solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288
.

Relevant Pages

  • Re: name of the calling method
    ... iTech Consulting Services Limited ... Expert in ePOS (Point-Of-Sales) solutions ... Website: http://www.itech.com.hk ...
    (comp.lang.php)
  • Re: Grid with columns[].currentcontrol being containers
    ... iTech Consulting Services Limited ... Expert in ePOS (Point-Of-Sales) solutions ... Website: http://www.itech.com.hk ...
    (microsoft.public.fox.programmer.exchange)
  • Re: form processing technique
    ... iTech Consulting Services Limited ... Expert in ePOS (Point-Of-Sales) solutions ... Website: http://www.itech.com.hk ...
    (comp.lang.php)
  • Re: Staying on topic
    ... iTech Consulting Services Limited ... Expert in ePOS (Point-Of-Sales) solutions ... Website: http://www.itech.com.hk ...
    (comp.lang.javascript)
  • go to next object
    ... iTech Consulting Services Limited ... Expert in ePOS (Point-Of-Sales) solutions ... Website: http://www.itech.com.hk ...
    (microsoft.public.fox.programmer.exchange)