SQL Statement

[agreen10]

What is wrong with the statement below: it is proving all status' although one is specified and all grades although specified.

{sites.program_id} = "1" and
{students.program_id} = 1 and
{students.semester} = "School Year" and
{students.year} = 2005 and
{sites.year} = 2005 and
{sites.semester} = "School Year" and
if {?School Name} = "*" Then True
Else
{sites.site_name} = {?School Name} and
{students.grade} = {?Student Grade} and
{students.application_status} = {?Status} and
{@join2fields}

 

[lbass]

{sites.program_id} = "1" and
{students.program_id} = 1 and
{students.semester} = "School Year" and
{students.year} = 2005 and
{sites.year} = 2005 and
{sites.semester} = "School Year" and
(
if {?School Name} = "*" Then True
Else
{sites.site_name} = {?School Name}
) and
{students.grade} = {?Student Grade} and
{students.application_status} = {?Status} and
{@join2fields}

-LB