Hi community,

I need to convert the following T-SQL into Jet-SQL. Does anyone know how to do that?

  SELECT Col FROM (
  SELECT DISTINCT Col1 AS Col
				  ,DENSE_RANK () OVER (ORDER BY Col1) L1
				  ,0 L2
				  ,0 L3
  FROM [dbo].[ThreeLevel]

  UNION ALL

  SELECT DISTINCT '    '  + Col2
				  ,DENSE_RANK () OVER (ORDER BY Col1) L1
				  ,DENSE_RANK () OVER (ORDER BY Col2) L2
				  ,0 L3
  FROM [dbo].[ThreeLevel]

  UNION ALL

  SELECT DISTINCT '        ' + Col3
				  ,DENSE_RANK () OVER (ORDER BY Col1) L1
				  ,DENSE_RANK () OVER (ORDER BY Col2) L2
				  ,DENSE_RANK () OVER (ORDER BY Col3) L3
  FROM [dbo].[ThreeLevel]

  ) AS tl
  ORDER BY tl.L1, tl.L2, tl.L3 

Sorry but what is Jet-SQL? Used by Access?