J
Jay
I have a table view with the following fields:
fr_mileage
fr_24
fr_36
fr_48
What I want is a query/stored proc that returns
all fr_24 values where fr_mileage=40
all fr_36 values where fr_mileage=60
all fr_48 values where fr_mileage=80
I appreciate this is probably going to involve subqueries but can't seem to
get it right.
ANY help greatly appreciated......thanks, Jason
fr_mileage
fr_24
fr_36
fr_48
What I want is a query/stored proc that returns
all fr_24 values where fr_mileage=40
all fr_36 values where fr_mileage=60
all fr_48 values where fr_mileage=80
I appreciate this is probably going to involve subqueries but can't seem to
get it right.
ANY help greatly appreciated......thanks, Jason