use group by clause after where clause
strsql =
"Select distinct sno,companyname,mobileno from Real where Emi='" & emira & "'
and count('" & siz & "')>0 and '" & siz & "'price<='" & price & "' and '" &
siz & "'price>'" & rentprice & "' and area='" & area.SelectedItem.Text & "'"
group by sno,companyname,mobileno
On Mon, Jun 22, 2009 at 3:28 AM, Jeena Ajiesh <[email protected]> wrote:
> Hi all,
> While i was trying to select some records from db it show 1 error,
>
> *An aggregate may not appear in the WHERE clause unless it is in a
> subquery contained in a HAVING clause or a select list, and the column being
> aggregated is an outer reference.
> *
> How can i solve this problem?
>
> My sql query is as follows
> **
>
> Dim emira, siz, price, rentprice As String
>
> emira = emi.SelectedItem.Text (Place)
>
> siz = size.SelectedItem.Text (Eg: 0,1, 2, 3)
>
> Dim strsql As String
>
> strsql =
> "Select distinct sno,companyname,mobileno from Real where Emi='" & emira &
> "' and count('" & siz & "')>0 and '" & siz & "'price<='" & price & "' and
> '" & siz & "'price>'" & rentprice & "' and area='" &
> area.SelectedItem.Text & "'"
> Can anyone help me to modify this query?
>
> --
> ****************
> Thanks & Regards,
> Jeena Ajiesh
> Email: [email protected]
> [email protected]
>
>
--
Regards
Khan Abuzaid
9870010998
Mumbai
