I know the problem is in left outer join but that record exists in table c with the fieldstatus = 100.

i need only those records in result set on which the fieldstatus has the value = 0 or there is no record exist in that table.

thanks,
...ashish