Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Group info
Members: 514
Language: English
Group categories:
Computers > Software
More group info »
Recent pages and files
Query: Total Credits without Sort Codes, by Primary Provider    
SELECT
  p.provcode,
  r.provlname,
  SUM(amount)
FROM
  journal j,
  patients p,
  providers r
WHERE
  j.ptnum=p.ptnum AND
  p.providernum=r.providernum AND
  j.trandate BETWEEN '2000-03-01' and '2000-03-15' AND
  j.sortcode is null
GROUP BY
  patients.provcode, providers.provlname
Version: 
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google