HELP with code and results display

From: mj <>
Date: Fri, 15 Apr 2011 12:14:57 -0700 (PDT)
Message-ID: <>

here's test code and results from same.

SELECT distinct
(SELECT count(*) FROM TABLE1)*100/(SELECT count(*) FROM TABLE2) percent
FROM TABLE1, TABLE2 Results = 46.571428571428571428571428571428571429

I'm trying to get a percentage as result, displayed as "46.57%" but can't figure out how to trip decimals and display the percent sign.

Any help would be much appreciated.

Thanks Received on Fri Apr 15 2011 - 14:14:57 CDT

Original text of this message