On 01/22/2009 07:19 PM, Grzegorz Jaśkiewicz wrote: > try making it in two steps,using temp table maybe. > how many rows does the subselect generate ?
the subselect returns 57.000 rows. -- [ Clemens Schwaighofer -----=====:::::~ ] [ IT Engineer/Web Producer/Planning/Manager ] [ E-Graphics Communications SP Digital ] [ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ] [ Tel: +81-(0)3-3545-7706 Fax: +81-(0)3-3545-7343 ] [ http://www.e-gra.co.jp ]
signature.asc
Description: OpenPGP digital signature
