Skip to Content
0
Former Member
Nov 27, 2009 at 06:11 AM

Qty nationality

30 Views

hai expert...

I have this query and I try not to work

how to make this query work for display like this:

1

SELECT

T0.Project, T0.U_Hotel, COUNT(T0.U_Hotel) AS 'Qty Hotel' ,

T0.[U_Nationality],COUNT(T0.[U_Nationality]) AS 'QtyNationality '

FROM DBO.OINV T0

WHERE

T0.Project >= '[%0]' AND T0.Project <= '[%1]'AND

T0.U_Hotel >= '[%2]' AND T0.U_Hotel <= '[%3]'AND

T0.[TaxDate]= '[%4]' AND T0.[U_Nationality] = '[%5]'AND

Group By T0.Project, T0.U_Hotel

how to make this query work for display like this:

ProjectCode, Hotel ,Tot Hotel, Nationality, Tot Natinality

AAA, XXX, 5, AU, 15

2. SELECT

T0.Project, T0.[U_Nationality], COUNT(T0.[U_Nationality]) AS 'QtyNationality'

FROM DBO.OINV T0

WHERE

T0.Project >= '[%0]' AND T0.Project <= '[%1]'AND

T0.[U_Nationality]>= '[%2]' AND T0.[U_Nationality] <= '[%3]'

T0.[TaxDate]>= '[%4]' AND T0.[U_Nationality] <= '[%5]'AND

Group By T0.Project, T0.[U_Nationality], T0.[TaxDate]

how to make this query work for display like this:

ProjectCode,Nationality, Tot Natinality

AAA,AU, 5

thx for all