hi all
i have to Display records not Count, how do i archive this. in the below Query .
Code:SELECT A.PROPERTY_KEY - B.[UNITS IN PRO-V] FROM (SELECT COUNT(DISTINCT PROPERTY_KEY) PROPERTY_KEY FROM sde.VW_Toi_Deeds_Vuyiswa WHERE FUNCTION_KEY like '%GEOSS%') A, (SELECT COUNT(*) AS [UNITS IN PRO-V] FROM SDE.PROPERTY WHERE FUNC_KEY LIKE 'GEOSS%') B


Reply With Quote