2 Query with same criteria giving different number of rows

2003-10-22 Thread Hector Del Curto
I have this 2 queries: SELECT COUNT(DISTINCT(LEFT(p.prod_num,5))) FROM products p, tlines l, prod_line pl WHERE l.Line = 'Solaris' AND l.id=pl.line_id AND pl.prod_id = p.id_product SELECT DISTINCT(LEFT(p.prod_num,5))as prod_num, p.description AS description,l.Line as line,l.Content as content FRO

loosing connection

2002-08-13 Thread Hector Del Curto
with the flush command. Any ideas of why that happens? Best Regards, Hector Del