|
Mike, It's a while since I checked how much faster this is than using two conditions, but if you want a unique ID to use in a single join condition you can do this: SELECT [S1].[Height (I)], [S2].[Height (I)] FROM [S1] JOIN [S2] ON [S1].[Y (I)] * PixelsByX("S1") + [S1].[X (I)] = [S2].[Y (I)] * PixelsByX("S2") + [S2].[X (I)] ; Or, with pre-preparation (more RAM usage I think, but possibly faster to join): SELECT [T1].[Height (I)], [T2].[Height (I)] FROM (SELECT [Y (I)] * PixelsByX("S1") + [X (I)] AS [ID], [Height (I)] FROM [S1] ) AS [T1] INNER JOIN (SELECT [Y (I)] * PixelsByX("S2") + [X (I)] AS [ID], [Height (I)] FROM [S2] ) AS [T2] ON [T1].[ID] = [T2].[ID] ;
|