Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.osn.de!newsfeed.completel.de!news.netway.at!not-for-mail From: Hans Sieghart Newsgroups: comp.databases,comp.databases.ibm-db2,comp.databases.theory,microsoft.public.fox.vfp.queries-sql Subject: Re: replace subquery with left join Date: Mon, 11 Nov 2002 16:38:52 +0100 Organization: UTA/netway (Customer) Lines: 20 Message-ID: References: <9e8isusncdod1udr3stm8dgk9tim8lvl9l@4ax.com> NNTP-Posting-Host: mail-gw.frischeis.at Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: newsreader1.netway.at 1037028997 6759 62.218.25.178 (11 Nov 2002 15:36:37 GMT) X-Complaints-To: abuse@netway.at NNTP-Posting-Date: 11 Nov 2002 15:36:37 GMT X-Newsreader: Forte Agent 1.8/32.548 Xref: newsfeed1.easynews.com comp.databases:96138 comp.databases.ibm-db2:69304 comp.databases.theory:23544 microsoft.public.fox.vfp.queries-sql:6862 X-Received-Date: Mon, 11 Nov 2002 08:36:23 MST (news.easynews.com) Finally! I've got a solution which satisfies me needs. It's based on Igor's proposal: First I create a view in a temporary library (QTEMP in DB2), then I get the date from that view. The whole operation lasts about 6 seconds and NULLs are also in the result. The only disadavantage is that I have to use SQL-Pass-Through. So I can't store the view-definition of the result in a local FoxPro-database and I have to put the code in every application where I need the prices. But speed is more important. :-) Thanks to everybody who participated! -Hans