Advertisement
Guest User

Untitled

a guest
Oct 7th, 2015
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. select sum(ExtendedListPrice*2) from cart_item a join cartitem2 b on a.id = b.CART_ITEM_ID join PRODUCT_TYPES_DEFN c on a.PRODUCTTYPE_CD = c.PRODUCTTYPE_CD where a.USERID = 164 and a.CART_ID = 26 and c.PRODUCTTYPE_NAME in ('RBA-Integration Pack', 'RBA-Integration Pack', 'Optional Components', 'Telephony Port Pack - Language', 'Dedicated Port Pack', 'Reserved Port Pack', 'New User Pack', 'Base Product') and a.CATALOGCODE in ('INSDAUB-0415','INSDA-0415','PSF-0713-01','INSOD-0715','INSOSD-0715','INSOAPI-0715','INSOTS-0715','INSORS-0715','INSOIM-0715')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement