I'm having an issue joining two tables an suspect it's due to the integer value within the tables. In SQL, I'd join like this:
SELECT top 1000 * FROM tblOrderRouteStops R WITH(NOLOCK)
INNER JOIN tblOrderRouteStopsParcelAssigned PA WITH(NOLOCK)
ON R.PKID = PA.ORSID
INNER JOIN tblOrderRouteStopsParcel P WITH(NOLOCK) ON
PA.ParcelID = P.PKID
When attempting to join in Sisense the join values are not showing as optional. In tblorderroutestops, PKID is represented as an 8 digit integer and in tblorderroutestopsparcelassigned ORSID is represented as an 8 digit integer WITH TWO decimals.
Is there a work around here?
