Select
chg.[Chart Number] chgChart,
pay.[Chart Number] payChart,
chg.[Case Number] chgCase,
pay.[Case Number] payCase,
PAX."Payment Amount",
PAX."Payment Reference",
PAX."Charge Reference"
From MWPAX pax, MWTRN chg, MWTRN pay
where
 chg."Entry Number" = pax."Charge Reference"
 and pax."Payment Reference" = pay."Entry Number"
 and chg."Chart Number" <> pay."Chart Number"


Select
chg.[Chart Number] chgChart,
pay.[Chart Number] payChart,
chg.[Case Number] chgCase,
pay.[Case Number] payCase,
PAX."Payment Amount",
PAX."Payment Reference",
PAX."Charge Reference"
From MWPAX pax, MWTRN chg, MWTRN pay
where
 chg."Entry Number" = pax."Charge Reference"
 and pax."Payment Reference" = pay."Entry Number"
 and chg."Chase Number" <> pay."Case Number"


Select 
cas.[Chart Number] casChart,
trn.[Chart Number] trnChart
From MWTRN trn, MWCAS cas
where
 trn."Case Number" = cas."Case Number"
 and trn.[Chart Number] <> cas.[Chart Number]



Select 
MWTRN."Chart Number",
MWTRN."Case Number",
MWTRN."Date From",
MWTRN."Procedure Code",
MWTRN."Description",
MWPAX."Payment Amount",
MWPAX."Payment Reference"
 from MWTRN, MWPAX
where
 MWPAX."Payment Reference" = MWTRN."Entry Number"
 and MWPAX."Charge Reference" = 79079
 
Order By "Date From"

Select * from MWPAX where "Payment Reference" = 80345
Select * from MWPAX where "Charge Reference" = 79079
Delete from MWPAX where "Charge Reference" >= 2000000001
Select * from MWPAX where "Charge Reference" > 85209 Order By "Charge Reference"


Select
[Deposit ID],
Sum(amount),
[Payment Amount]
From MWTRN, MWDEP
Where
 MWTRN.[Deposit ID] = MWDEP.[Entry Number]
and [Transaction Type] >= 'I'
and [Transaction Type]  <= 'O'
and [Date From] >= '09/30/2011'
and [Date From] <= '10/06/2011'

Group By [Deposit ID], [Payment Amount]