Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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`
- 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
- 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%')
- ORDER BY Payments_Charges.SectionCode ASC, Payments_Charges.MatterReference ASC
Advertisement
Add Comment
Please, Sign In to add comment