Sorry for the earlier email:
I am making some guesses here
"tbl_Survey2006"."foss_supt_biz" is a boolean
"tbl_BizContact"."biz_id" is the primary key, so can't be null
all the others are not booleans
So this is the query
SELECT
"tmp1"."ContactRecords" AS "ContactRecords",
"tmp1"."ContactNames" AS "ContactNames",
"tmp2"."AverageAge" AS "AverageAge",
"tmp2"."fossSuptCnt" AS "fossSuptCnt"
FROM
( SELECT
COUNT( "tbl_BizContact"."biz_id" ) AS "ContactRecords",
COUNT("tbl_BizContact"."biz_name" ) AS "ContactNames"
FROM "tbl_BizContact"
HAVING "tbl_BizContact"."biz_name"
) "tmp1"
,
(SELECT
AVG( "tbl_Survey2006"."biz_age") AS "AverageAge",
COUNT( "tbl_Survey2006"."foss_supt_biz" ) AS "fossSuptCnt"
FROM "tbl_Survey2006"
HAVING "tbl_Survey2006"."foss_supt_biz" = TRUE
AND "tbl_BizContact"."biz_name" IS NOT NULL
) "tmp2"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
