Erweiterte Suche   Basiswert: Alle SELECT DERIVEDTBL2.UNDERLYINGNAME UnderlyingName, SiteWarrants.UnderlyingId UnderlyingId FROM (Select ps.ProductId, ps.Name WARRANTNAME, ps.Expiry EXPIRY, ps.UnderlyingId,ps.ISIN, ps.RIC, w.CallPutType CALLPUTTYPE FROM Products_Underlyings ps INNER JOIN WARRANTS w ON ps.ProductId = w.ProductId INNER JOIN TradingExchange ON ps.productid = TradingExchange.ProductId INNER JOIN Exchange ON TradingExchange.ExchangeId = Exchange.ExchangeId where ps.ProductTypeId = 4 AND ps.ActiveProduct= 1 AND Exchange.ExchangeCode = 'GER') SiteWarrants LEFT JOIN (SELECT Products_Underlyings.Name UNDERLYINGNAME, Products_Underlyings.ProductId FROM Products_Underlyings INNER JOIN Sectors ON Products_Underlyings.SectorId = Sectors.SectorId WHERE (Products_Underlyings.ProductId IN (SELECT DISTINCT UnderlyingId FROM Products_Underlyings))) DERIVEDTBL2 ON SiteWarrants.UnderlyingId = DERIVEDTBL2.ProductId GROUP BY UNDERLYINGNAME, UnderlyingID ORDER BY DERIVEDTBL2.UnderlyingName ASCADIDAS SALOMONALLIANZ AGAltana common ShareBASF COMMON SHAREBAYER AGBAYERISCHE HYPO UND VEREIBMWCOMMERZBANK COMMON SHARECONTINENTAL AGDAIMLERCHRYSLER AGDAX INDEX GERMANYDEUTSCHE BANK AGDEUTSCHE LUFTHANSA AGDEUTSCHE POST COMMON SHARDEUTSCHE POSTBANK AGDEUTSCHE TELEKOM AGE.ONEUROSTOXX 50FRANCE TELECOMFRESENIUSHENKEL KGAA DUESSELDORFHYPOVEREINSBANKINFINEON COMMON SHAREMUENCHNER RUCK REG STOCKNASDAQ 100 CASH INDEXNIKKEI 225 CASH INDEXNOKIA A SHARESPHILIPSROYAL DUTCH PETROLEUM CORWE-AGSAP AGSCHERING COMMON SHARESIEMENS COMMON SHARET-ONLINE COMMON SHARETHYSSENKRUPP COMMON SHARETUIGVOLKSWAGEN AG WKN: ISIN Code: Produkte: (Alle) Warrants Discount Zertifikate Typ (Alle) Call Put Stil (Alle) Europäisch Amerikanisch   Reset