Forum Discussion

nmccutcheon's avatar
nmccutcheon
Data Storage
05-10-2023

Table Join

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?

Data Models