MySQL Forums
Forum List  »  Newbie

Re: Anyone know what is wrong here
Posted by: claudeless
Date: May 25, 2005 10:18PM

SELECT
`assets`.`MasterCusID` ,
`assets`.`CurrentVersion` ,
`assets`.`QuoteAsset` ,
`assets`.`VOIDED` ,
SUM(`assets`.`MultiNo`) ,
`assets`.`Orginal MODEL_NO` ,
`assets`.`Orginal PartNo` ,
`classofsoftware`.`Catagory` ,
`classofsoftware`.`CatDesciption` ,
`classofsoftware`.`Level` ,
`classofsoftware`.`Catagory` ,
`classofsoftware`.`CatDesciption` ,
@level:=(SELECT IF SUM(`assets`.`MultiNo`) =1 then @level:=1
elseIF SUM(`assets`.`MultiNo`) BETWEEN 2 AND 6 then @level:=2
elseIF SUM(`assets`.`MultiNo`) BETWEEN 7 AND 10 then @level:=3
elseIF SUM(`assets`.`MultiNo`) BETWEEN 11 AND 25 then @level:=4
elseIF SUM(`assets`.`MultiNo`) BETWEEN 26 AND 50 then @level:=5
elseIF SUM(`assets`.`MultiNo`) BETWEEN 51 AND 100 then @level:=6
elseIF SUM(`assets`.`MultiNo`) BETWEEN 101 AND 200 then @level:=7
elseIF SUM(`assets`.`MultiNo`) BETWEEN 201 AND 400 then @level:=8
elseIF SUM(`assets`.`MultiNo`) BETWEEN 401 AND 800 then @level:=9
elseIF SUM(`assets`.`MultiNo`) BETWEEN 801 AND 1500 then @level:=10
ELSE @LEVEL:=11)
END IF,
@rtp := ( SELECT `pricebook`.`Retail`
FROM pricebook ` Where ((pricebook.Category =classofsoftware.Catagory)
AND (pricebook`.`Level` = @level))



FROM `assets`
INNER JOIN `classofsoftware` ON ( `assets`.`Orginal MODEL_NO` = `classofsoftware`.`ModelNo` )
INNER JOIN `classofsoftware` ON ( `assets`.`Orginal MODEL_NO` = `classofsoftware`.`ModelNo` )

WHERE (`MasterCusID` = 20031511)
AND (`QuoteAsset` = 0)
AND (`VOIDED` = 0)

Group BY
`assets`.`CurrentVersion`,
`classofsoftware`.`Catagory`



I've Also Tried this

Options: ReplyQuote


Subject
Written By
Posted
Re: Anyone know what is wrong here
May 25, 2005 10:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.