Guest User

Untitled

a guest
Apr 24th, 2021
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. SELECT `Clients`.`Name`, `Clients`.`Address1`, `Clients`.`Address2`, `Clients`.`Address3`, `Clients`.`Address4`, `Clients`.`ClientCode`, `Matters`.`Clref`, `Matters`.`Name`, `Clients`.`TransferAmount`, `Payments_Charges`.`Date`, `Matters`.`MttrNo`, `Payments_Charges`.`Amount`, `Payments_Charges`.`SectionCode`, `Sections`.`Name`, `Sections`.`Address1`, `Sections`.`Address2`, `Sections`.`Address3`, `Sections`.`Address4`, `Payments_Charges`.`MatterReference`
  2. FROM ((CrystalReports.dbo.Payments_Charges Payments_Charges INNER JOIN CrystalReports.dbo.Matters Matters ON Payments_Charges.MatterReference = Matters.MttrNo) INNER JOIN CrystalReports.dbo.Sections Sections ON Payments_Charges.SectionCode = Sections.SectionCode) INNER JOIN CrystalReports.dbo.Clients Clients ON Matters.ClientCode = Clients.ClientCode
  3. WHERE Payments_Charges.Type = 'Croskerrys' AND Clients.ClientCode = '0436' AND (Matters.Clref LIKE '3000%' OR Matters.Clref LIKE '1000%' OR Matters.Clref LIKE '492109559%' OR Matters.Clref LIKE '49217770%' OR Matters.Clref LIKE '45537301%' OR Matters.Clref LIKE '41426146%' OR Matters.Clref LIKE '47156009%' OR Matters.Clref LIKE '45537300%' OR Matters.Clref LIKE '41426203%' OR Matters.Clref LIKE '41426180%' OR Matters.Clref LIKE '4966625569%')
  4. ORDER BY Payments_Charges.SectionCode ASC, Payments_Charges.MatterReference ASC
Advertisement
Add Comment
Please, Sign In to add comment