[RESOLVED] "If" statement in a SQL query???

[hadoob024]

I just came across this query and am not sure what's going on in this particular section of the SQL statement. I've never seen "if" statements in a SQL query. Tried googling this, but no example that I found matched what I was looking for. Here's the relevant part of the query.

select mfg.name as mfgname,ap.manufacturer_id,ap.po_id,mfg.req_facacct as ReqAcctNum,ifm.mfg_acct_num as FacNum,mfg.acctnumber,
if(fac.dtmcontract = 1 and ap.pay_facility = 0 and ap.facility_orders <> 'FacReorder','M',
if(fac.dtmcontract = 1 and ap.pay_facility = 0 and ap.facility_orders = 'FacReorder' and ap.inventorytype = 'Rep Delivery','M',
if(fac.dtmcontract = 0 and mfg.direct_bill = 1 and (ap.inventorytype = 'Rep Delivery' or ap.inventorytype = 'Drop Ship'),'M',
if(fac.dtmcontract = 0 and mfg.direct_bill = 1 and (ap.inventorytype = 'Purchased' or ap.inventorytype = 'Consigned'),'C',
if(fac.dtmcontract = 1 and ap.pay_facility = 0 and ap.facility_orders = 'FacReorder' and ap.inventorytype <> 'Rep Delivery','Z','C')))))
as potype
from actparts ap
.
.
.

[dagon]

first hit, when i googled:

11.3. Control Flow Functions

[hadoob024]

Thanks. I guess you put in better google search terms than me. I got some stuff that was close but with no example that I could use to compare.

[Weedpacket]

Or maybe he went to the manual first.

[hadoob024]

Uh, if you read my post, you can see that I did look there first. I just got confused because I didn't realize that the whole sequence worked like an if/elseif deal because all the examples I found were way more simplified than the one I have.

[Weedpacket]

hadoob024 wrote:

Uh, if you read my post, you can see that I did look there first.

Maybe in your first draft of the post, but you must have taken it out.