View Single Post
  #7 (permalink)  
Old July 17th, 2006, 05:32 AM
peeches peeches is offline
Registered User
 
Join Date: Jul 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi. I seem to be having a similar problem. I want to select columns based on the value of another column.

This is what I'm looking for:

if final = 0 then
select rate as rate_sug, depot as depot_sug from callinglistdetails
else
select rate as rate_fin, depot as depot_fin from callinglistdetails

Reply With Quote