cancel
Showing results for 
Search instead for 
Did you mean: 

Table Join

nmccutcheon
7 - Data Storage
7 - Data Storage

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?

0 REPLIES 0