Don,
It is a little hard for me to comment on the query because I don't
have the context I need. When I tackle problems like this I ignore the
query and ask what are you trying to DO? The queries you sent look
like tunnel vision to me; there is probably a better way to do what
you're trying to
I am hoping someone can bail me out on why this query in not working.
In the queries below:
query 1 returns multiple rows - one per client.
in the rows where:
client_id is 254240, dr_all_ther_qty = 1
client_id is 253821, dr_all_ther_qty = 1
client_id is 254023, dr_all_ther_qty = 6
But when I