No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
hi, i am a user of Toad for Oracle 8.6.1 i am having a problem contructing this query [COLOR=#0000f0]SELECT [/COLOR]FAC[COLOR=#0000f0].[/COLOR]FACILITY_ABBR hall_abbr[COLOR=#0000f0], [/COLOR]COUNT[COLOR=#0000f0]([/COLOR]HALLUNIT[COLOR=#0000f0].[/COLOR]ACCEPTS_MALES_FLAG[COLOR=#0000f0])[/COLOR] MISDEMEANOR_MALE[COLOR=#0000f0], [/COLOR]COUNT[COLOR=#0000f0]([/COLOR]HALLUNIT[COLOR=#0000f0].[/COLOR]ACCEPTS_FEMALES_FLAG[COLOR=#0000f0])[/COLOR] MISDEMEANOR_FEMALES [COLOR=#0000f0]FROM [/COLOR][COLOR=#808000]HALL_UNITS[/COLOR] HALLUNIT[COLOR=#0000f0], [/COLOR][COLOR=#808000]FACILITIES[/COLOR] FAC [COLOR=#0000f0]WHERE [/COLOR]HALLUNIT[COLOR=#0000f0].[/COLOR]HALL_ID [COLOR=#0000f0]=[/COLOR] FAC[COLOR=#0000f0].ID AND[/COLOR][COLOR=#000000] HALLUNIT[/COLOR][COLOR=#0000f0].[/COLOR][COLOR=#000000]ACCEPTS_MALES_FLAG [/COLOR][COLOR=#0000f0]=[/COLOR][COLOR=#ff0000]'T'[/COLOR] [COLOR=#0000f0]AND[/COLOR][COLOR=#000000] HALLUNIT[/COLOR][COLOR=#0000f0].[/COLOR][COLOR=#000000]ACCEPTS_FEMALES_FLAG [/COLOR][COLOR=#0000f0]=[/COLOR][COLOR=#ff0000]'T'[/COLOR][COLOR=#0000f0]GROUP[/COLOR][COLOR=#0000f0]BY [/COLOR]FAC[COLOR=#0000f0].[/COLOR]FACILITY_ABBR the result is: hall_abbr MISDEMEANOR_MALE MISDEMEANOR_FEMALES BJNJH 1 1 … 
|