Hello,

Please try below query...may be you have to tweak it to suit your requirement....hope this helps

SELECTdbo.salesExport.businessDate, dbo.salesExport.rvcID

, dbo.employee.employeeID, dbo.employee.employeeFName, dbo.employee.employeeLName

, dbo.salesExport.chargedReceipts, dbo.salesExport.grossReceipts - dbo.salesExport.chargedReceipts AS otherReceipts

, dbo.salesExport.grossReceipts, dbo.salesExport.discountTotal, dbo.salesExport.bqtSvc19, dbo.salesExport.bqtSvc20, CONVERT(numeric(18, 2),

dbo.salesExport.bqtSvc19 / 0.19 * - 1) AS bqt19Sales, CONVERT(numeric(18, 2), dbo.salesExport.bqtSvc20 / 0.20 * - 1) AS bqt20Sales,

CONVERT(numeric(18, 2), ((dbo.salesExport.grossReceipts + dbo.salesExport.discountTotal) + dbo.salesExport.bqtSvc19 / 0.19 * - 1)

+ dbo.salesExport.bqtSvc20 / 0.20 * - 1) AS netSales, dbo.salesExport.chargedTips, dbo.employee.microsEmployeeNumber,

ISNULL(dbo.tipTransactionPivot.cashTips, 0) AS cashTips, ISNULL(dbo.tipTransactionPivot.cashTipsOut, 0) AS cashTipsOut,

ISNULL(dbo.tipTransactionPivot.cashTipsIn, 0) AS cashTipsIn, ISNULL(dbo.tipTransactionPivot.chargeTipsOut, 0) AS chargeTipsOut,

ISNULL(dbo.tipTransactionPivot.chargeTipsIn, 0) AS chargeTipsIn

FROM dbo.tipTransactionPivot

FULL OUTER JOIN dbo.salesExport

ON dbo.tipTransactionPivot.employeeID = dbo.salesExport.microsEmployeeNumber

AND dbo.tipTransactionPivot.businessDate = dbo.salesExport.businessDate

AND dbo.tipTransactionPivot.rvcID = dbo.salesExport.rvcID

LEFT JOIN dbo.employee

ON dbo.employee.microsEmployeeNumber = dbo.tipTransactionPivot.employeeID