I need to understand what is wrong.
There is a joined table called T_GENDER.
I want to know how many males and how many females.
Created a Request to select Males : R_GenderM and another one for females : R_GenderF.
Then this one more request called R_GenderCount, in which I select as a source R_GenderF, crit=F-> result = 7
Code: Select all
SELECT COUNT( "Gender" ) FROM "R_GenderF"
Code: Select all
SELECT COUNT( "R_GenderF"."Gender" ), COUNT( "R_GenderM"."Gender" ) FROM "R_GenderF", "R_GenderM"
this code is not accepted :
Code: Select all
SELECT COUNT( "Gender" ) FROM "R_GenderF" , COUNT( "Gender" ) FROM "R_GenderM"
Edit: Changed subject, was Count Request Fail Make your post understandable by others -- MrProgrammer, forum moderator |