Joining a procedure

Article View: borland.public.interbase.sql

Article #610

Back to borland.public.interbase.sql Previous Next

#610

From: fusion35
Date: Thu, 16 Aug 2007 03:45

12 lines
1466 bytes

  select e.itemcode, e.sizeid, sum(d.monthqty*e.qty)  from saleschmst
m
  join saleschdet d on (d.compyrcode=m.compyrcode and d.invno=m.invno)
  left join extractassembly(d.itemcode, d.sizeid, 'N') e on (1=1)
  where m.compyrcode=4 and m.monthof=8 and e.itemcode is not null
  group by e.itemcode, e.sizeid

The query works in IB2007 but not in IB7.5 why?

regards

Devinder

Technical Details

Message-ID: <1187235904.825512.289670@q4g2000prc.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!q4g2000prc.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,408ede4505861ab9,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!q4g2000prc.googlegroups.com!not-for-mail
From:  fusion35@gmail.com
Newsgroups: borland.public.interbase.sql
Subject: Joining a procedure
Date: Wed, 15 Aug 2007 20:45:04 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <1187235904.825512.289670@q4g2000prc.googlegroups.com>
NNTP-Posting-Host: 122.162.4.26
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1187235905 14313 127.0.0.1 (16 Aug 2007 03:45:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 16 Aug 2007 03:45:05 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: q4g2000prc.googlegroups.com; posting-host=122.162.4.26;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0