need to find all rows from drive where the driveid is in the expensereport table
select drives.driveid as 'Apple.drives.driveID', ExpenseReport.driveID as 'Po.ExpenseReport.driveID'
from ExpenseReport with(nolock)
inner join aserver.apple.dbo.drives drive with(nolock) on ExpenseReport.driveID = drive.driveid
where drive.driveid = ExpenseReport.driveID
my error: Error on the 1st line: Conversion failed when converting the varchar value 'No send me to confirmation page now' to data type int.