Re: Query Help!!

neal.l.leitner writes: > select file_no from xyz > where text = "MURDER" > INTO TEMP T1;> > select file_no from xyz > where text = "MYSTERY" > INTO TEMP T2;> > select t1.file_no from t1,t2 > where t1.file_no=t2.file_no;> > *This is faster, but as fast as I would like to have it run. Can you join it to itself, with something like this ? select a.file_no from xyz a, xyz b where a.file_no = b.file_no and a.text = "MURDER" and b.text = "MYSTERY"; If you can, is that slower/faster ? (sorry, I don't have 130,000 rows to play with at the moment :-) Or is the point that they can pick lots of keywords (in which case I probably blew it completely) ? If so, you might UNION all the individual SELECTs into a temp table and then self-join that. > Neal Leitner > AT&T Bell Labs > (201) 564-2463 Good luck ... Cheers - Tony. PS. It's bucketting down with rain. Does anyone have a spare warm-climate job ? __________________________________________________________________________ Tony Heskett th@bnr.co.uk Voice: (+44) 279 402637 BNR, London Road, Harlow, Essex, CM17 9NA Fax: (+44) 279 454187