Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102

    Need help in creating a View in MySQL 5.0.51a Open Source DB


    Hello everyone,

    I have been tasked to create a view within our MySQL 5.0.51a Open Source database, here is a copy of an existing code for another view that has many of the same elements as will be needed or used within the new view. I do not have all the tables and columns yet that I need to include in this new view, but here is the code of a very good example of what it might be like.

    Example:

    DROP VIEW IF EXISTS Type1Query ;
    CREATE SQL SECURITY INVOKER VIEW Type1Query AS
    SELECT
    x.Cusip AS CUSIP,
    t.Ticker AS TICKR1,
    t.NasdTicker AS TICKR2,
    t.CanadianTicker AS TICKR3,
    x.ISIN AS ISIN,
    x.Sedol AS SEDOL,
    SUBSTRING(d9.IssueDescription, 1, 31) AS NAME_1,
    SUBSTRING(d9.IssueDescription, 32, 32) AS NAME_2,
    b.PrimaryCurrency AS CRNC_CD,
    currency.Currency AS CRNC_NA,
    d9.IssuerCountry AS IS_US_CD,
    CASE WHEN d9.IssuerCountry = 'USA' THEN 'United States'
    WHEN d9.IssuerCountry = 'CAN' THEN 'Canada'
    WHEN d9.IssuerCountry = 'OUT' THEN 'Non-North American Security'
    ELSE country.Country END AS IS_US_NA,
    nyseexch.Code AS EXC1_CD,
    nyseexch.Exchange AS EXC1_NA,
    nasdexch.Code AS EXC2_CD,
    nasdexch.Exchange AS EXC2_NA,
    canexch.Code AS EXC3_CD,
    canexch.Exchange AS EXC3_NA,
    b.OrigPaymentRate AS CUR_RATE,
    b.OrigPaymentRate AS MBS_RATE,
    b.CurrentCouponRate AS CPN_RATE,
    CASE WHEN b.MaturityDate = 0000-00-00 THEN '' ELSE b.MaturityDate END AS MAT_DATE,
    CASE WHEN b.AccrualBeginDate = 0000-00-00 THEN '' ELSE b.AccrualBeginDate END AS ISS_DAT,
    CASE WHEN b.FirstPaymentDate = 0000-00-00 THEN '' ELSE b.FirstPaymentDate END AS 1ST_CPN,
    CASE WHEN b.LastPaymentDate = 0000-00-00 THEN '' ELSE b.LastPaymentDate END AS LST_CPN,
    m.PoolNumber AS POOL_ID,
    CASE WHEN m.DelayInPayment = '' THEN m.InterestPaymentDelay ELSE m.DelayInPayment END AS DELAY,
    o.StrikePrice AS STRIKE,
    CASE WHEN o.ExpirationDate = 0000-00-00 THEN '' ELSE o.ExpirationDate END AS EXP_DATE,
    a.AssetCategory AS ATYPE_CD,
    assetcat.Description AS ATYPE_NA,
    m.TrancheType AS CTYPE_CD,
    tranchetype.Description AS CTYPE_NA,
    CONCAT(sectype1.Code, sectype2.Code) AS STYPE_CD,
    CONCAT(sectype1.Description, '/', sectype2.Description) AS STYPE_NA,
    d9.IssuerType AS ITYPE_CD,
    issuertype.Description AS ITYPE_NA,
    d9.SecurityType AS SECTYPE,
    '' AS TYPM_CD,
    '' AS TYPM_NA,
    m.CollateralDescription AS TYPE1_CD,
    collateral.Description AS TYPE1_NA,
    d9.CollateralType AS TYPE2_CD,
    colltype.Description AS TYPE2_NA,
    b.OrigAccrualBasis AS DAYCT_CD,
    odaycount.Description AS DAYCT_NA,
    b.AccrualBasis AS ALTDC_CD,
    accrualbasis.Description AS ALTDC_NA,
    i.OrigPaymentFrequency AS PFREQ_CD,
    opayfreq.Description AS PFREQ_NA,
    d9.CurrentPaymentFreq AS ALTPF_CD,
    payfreq.Description AS ALTPF_NA,
    d9.IssuerSICCode AS SIC_CD,
    sicmajgrp.Description AS SIC_NA,
    d9minor.NaicsCodePrimary AS NAIC1_CD,
    '' AS NAIC1_NA,
    d9minor.NaicsCodeSecondary AS NAIC2_CD,
    '' AS NAIC2_NA,
    d9minor.NaicsCodeTertiary AS NAIC3_CD,
    '' AS NAIC3_NA,
    m.Agency AS AGNCY_CD,
    agency.Description AS AGNCY_NA,
    d9.IssuerIncorpCountry AS CNTRY_CD,
    isocountry.Country AS CNTRY_NA,
    CAST(d9.IssueSize / 100 AS UNSIGNED) AS OPOOL,
    CAST(d9.Outstanding / 100 AS UNSIGNED) AS FLTSIZ,
    d9.Rule144AInd AS R144A,
    '' AS INDFLT,
    '' AS CONV_COD,
    m.CMO_IO_POInd,
    d9.FederalTaxStatus AS FED_TAX,
    d9.StateTaxStatus AS STATE_TAX,
    t.ExchangeStatus AS TCKR1_STAT,
    t.NasdStatus AS TCKR2_STAT,
    t.CanadianStatus AS TCKR3_STAT,
    x.CrossReferenceSedol1 AS XSEDOL1,
    x.CrossReferenceSedol2 AS XSEDOL2,
    x.CrossReferenceSedol3 AS XSEDOL3,
    x.CrossReferenceSedol4 AS XSEDOL4,
    x.CrossReferenceSedol5 AS XSEDOL5,
    b.AdjustableInd AS ADJ_IND,
    c3.ConvExerciseSecID AS UNDER_ID,
    c3.ConvExerciseRate AS CONV_EXCH_RATE,
    CASE WHEN o.UnderlyingSecurityID = ''
    THEN dz.Issuer
    ELSE LEFT(d9u.IssueDescription,31)
    END AS ISSUER,
    x.SecurityID AS PRIMARY_DB_KEY
    FROM
    RecordX x
    LEFT JOIN RecordD9Major d9 ON x.SecurityID = d9.SecurityID
    LEFT JOIN RecordD9Minor d9minor ON x.SecurityID = d9minor.SecurityID
    LEFT JOIN RecordDZ dz ON x.SecurityID = dz.SecurityID
    LEFT JOIN RecordT t ON x.SecurityID = t.SecurityID
    LEFT JOIN RecordB b ON x.SecurityID = b.SecurityID
    LEFT JOIN RecordM m ON x.SecurityID = m.SecurityID
    LEFT JOIN RecordO o ON x.SecurityID = o.SecurityID
    LEFT JOIN RecordA a ON x.SecurityID = a.SecurityID
    LEFT JOIN RecordI i ON x.SecurityID = i.SecurityID
    LEFT JOIN RecordC3 c3 ON x.SecurityID = c3.SecurityID
    LEFT JOIN RecordD9Major d9u ON o.UnderlyingSecurityID = d9u.SecurityID
    LEFT JOIN refISOCurrencyCode currency ON b.PrimaryCurrency = currency.Code
    LEFT JOIN refISOCountryCode country ON d9.IssuerCountry = country.Code
    LEFT JOIN refFTExchangeCode nyseexch ON t.ExchangeCode = nyseexch.Code
    LEFT JOIN refFTExchangeCode nasdexch ON t.NasdCode = nasdexch.Code
    LEFT JOIN refFTExchangeCode canexch ON t.CanadianCode = canexch.Code
    LEFT JOIN refAssetCategory assetcat ON a.AssetCategory = assetcat.Code
    LEFT JOIN refTrancheType tranchetype ON m.TrancheType = tranchetype.Code
    LEFT JOIN refIssuerTypeCode issuertype ON d9.IssuerType = issuertype.Code
    LEFT JOIN refSecurityType sectype1 ON SUBSTRING(d9.SecurityType,1,1) = sectype1.Code AND sectype1.Position = 1 AND LOCATE(a.AssetCategory, sectype1.AssetCategories) <> 0
    LEFT JOIN refSecurityType sectype2 ON SUBSTRING(d9.SecurityType,2,1) = sectype2.Code AND sectype2.Position = 2 AND LOCATE(a.AssetCategory, sectype2.AssetCategories) <> 0
    LEFT JOIN refCollateralDescription collateral ON m.CollateralDescription = collateral.Code
    LEFT JOIN refCollateralType colltype ON d9.CollateralType = colltype.Code AND LOCATE(assetcat.Code, colltype.AssetCategories) <> 0
    LEFT JOIN refOriginalDaycountBasis odaycount ON b.OrigAccrualBasis = odaycount.Code
    LEFT JOIN refAccrualBasis accrualbasis ON b.AccrualBasis = accrualbasis.Code AND LOCATE(assetcat.Code, accrualbasis.AssetCategories) <> 0
    LEFT JOIN refOriginalPaymentFrequency opayfreq ON i.OrigPaymentFrequency = opayfreq.Code
    LEFT JOIN refCurrentPaymentFrequency payfreq ON d9.CurrentPaymentFreq = payfreq.Code AND LOCATE(assetcat.Code, payfreq.AssetCategories) <> 0
    LEFT JOIN refSICMajorGroupCode sicmajgrp ON SUBSTRING(d9.IssuerSICCode, 1, 2) = sicmajgrp.Code
    LEFT JOIN refGuaranteeingAgency agency ON m.Agency = agency.Code
    LEFT JOIN refISOCountryCode isocountry ON d9.IssuerIncorpCountry = isocountry.Code
    ORDER BY a.SirsIDMarker ASC;
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,957
    Rep Power
    1046
    Um ... what exactly are we supposed to do now?
    The 6 worst sins of securityHow to (properly) access a MySQL database with PHP

    Why can’t I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,124
    Rep Power
    4274
    you did not actually ask a question, so all i can say is good luck brother

    i've been working with sql for many many years, and i hardly ever see anything that complex
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    I will add the requested specs tomorrow, I should also say I am a DBA and not a true SQL Developer...my hats off to you Developer types....!!! I wish I had the skills that you guys have.
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    Ok I finally got the specs of the request...

    three tables:

    RecordB
    RecordFB
    RecordF_FRNFormula

    9 columns from RecordB table
    2 columns from RecordFB
    2 columns from recordF_FRNFormula

    need to pull which cusips have floaters based on a benchmark from sirs DB

    Based on a security Id or list of security ids need the following fields from sires. If the field is a code, we always want the description of the code form the related reference table.
    >From Record B> AdjustableInd, AccrualBasis,FirstPaymentdate, FloaterType, FloaterRecordInd,CurrentDeterminationDate,CurrentResetEffectiveDate,RateResetFrequency, NextResetEffectiveDate,

    >From Record FB> ResetDayofMonth,ResetDayofWeek
    >From Record F_FRNFormula>FormulaText, FormulaConditionHandlingCode.


    So there seems that some of these fields have a value that relates to yet another table that I will have to add more logic to this base code view still. Need to get how that works yet. Now to write the base view so far from what I do have.
    Last edited by ByGoneYrs; May 23rd, 2013 at 02:34 PM.
  10. #6
  11. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    Ok sofar I have the following...

    DROP VIEW IF EXISTS v_floating_rate_info;
    CREATE SQL SECURITY INVOKER VIEW v_floating_rate_info as
    SELECT
    a. AdjustableInd, a. AccrualBasis, a. FirstPaymentdate, a. FloaterType, a. FloaterRecordInd,
    a. CurrentDeterminationDate, a. CurrentResetEffectiveDate, a. RateResetFrequency,
    a. NextResetEffectiveDate,
    b. ResetDayofMonth, b. ResetDayofWeek,
    c. FormulaText, c. FormulaConditionHandlingCode
    FROM RecordB a, RecordFB b, RecordF_FRNFormula c
    Where…..


    Now each of these columns has a referencial table and with that they have codes that relate to what might be in each coloumn for any given records

    for example: a.Adjustableind column in table RecordB has a ref table of :


    refAdjustableRateIndicator CREATE TABLE `refAdjustableRateIndicator` (
    `Code` char(1) NOT NULL,
    `Description` varchar(255) default NULL,
    PRIMARY KEY (`Code`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1


    mysql> select code, description from refAdjustableRateIndicator;

    Not available
    F Floating or adjustable rate security
    I Inverse floating rate security
    N Not a floating or adjustable rate security
    Z Other situation

    so for each column in this case a.Adjustableind I need to further define each of the above codes ( blank, F,I,N,Z) .

    It looks like I must do this for 5 columns
    a. AdjustableInd, a. AccrualBasis, a. FloaterType, a. FloaterRecordInd,a. RateResetFrequency

    now to try and figure out how to do that next...LOL If someone can help me out with the first column a. AdjustableInd I can figure this out for the other 4 that have different ref tables and columns and details ...

    NOTE: my goal here isn't to just resolve the current issue but to better understand and learn more
    Last edited by ByGoneYrs; May 23rd, 2013 at 03:01 PM.
  12. #7
  13. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,124
    Rep Power
    4274
    the first thing you need to do is get the query working that uses just the columns from the three base tables, before translating codes into descriptions

    also, some basic formatting will help

    Code:
    SELECT a. AdjustableInd
         , a. AccrualBasis
         , a. FirstPaymentdate
         , a. FloaterType
         , a. FloaterRecordInd
         , a. CurrentDeterminationDate
         , a. CurrentResetEffectiveDate
         , a. RateResetFrequency
         , a. NextResetEffectiveDate
         , b. ResetDayofMonth
         , b. ResetDayofWeek
         , c. FormulaText
         , c. FormulaConditionHandlingCode
      FROM ...
    but the most important first step is to write the FROM clause properly...
    Code:
      FROM RecordB a
    INNER
      JOIN RecordFB b
        ON b.somecolumn = a.somecolumn
    INNER
      JOIN RecordF_FRNFormula c
        ON c.somecolumn = a.somecolumn
    your job is to change "somecolumn" in all cases to the correct columns to join the tab les properly
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  14. #8
  15. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    OK thanks I will get to work on that first...thanks!
  16. #9
  17. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    ok the 5 columns that have to relate with each other are all from table RecordB. Each of these columns referes to another referential table of:

    AdjustableInd to refAjustableRateIndicator
    AccrualBasis to refAccrualBasis
    FloaterType to refFloaterType
    FloaterRecordInd to refFloaterRecordIndicator
    RateResetFrequency to refRateResetFrequency

    Example:

    mysql> show create table refAdjustableRateIndicator;
    +----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Table | Create Table |
    +----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | refAdjustableRateIndicator | CREATE TABLE `refAdjustableRateIndicator` (
    `Code` char(1) NOT NULL,
    `Description` varchar(255) default NULL,
    PRIMARY KEY (`Code`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
    +----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    1 row in set (0.00 sec)

    mysql> select count(*), AdjustableInd from RecordB group by AdjustableInd;
    +----------+---------------+
    | count(*) | AdjustableInd |
    +----------+---------------+
    | 25989 | NULL |
    | 417452 | F |
    | 69087 | I |
    | 4634720 | N |
    | 3950 | R |
    | 2810 | Z |
    +----------+---------------+
    6 rows in set (0.00 sec)

    mysql> select count(*), Code, Description from refAdjustableRateIndicator group by Code;
    +----------+------+--------------------------------------------+
    | count(*) | Code | Description |
    +----------+------+--------------------------------------------+
    | 1 | | Not available |
    | 1 | F | Floating or adjustable rate security |
    | 1 | I | Inverse floating rate security |
    | 1 | N | Not a floating or adjustable rate security |
    | 1 | Z | Other situation |
    +----------+------+--------------------------------------------+
    5 rows in set (0.00 sec)


    So how do I write the join for the Column of AdjustableInd in the RecordB table to the data from the refAdjustableRateIndicator data from it's tow columns of Code and Description?
  18. #10
  19. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    So for the example of the a.AdjustableInd column in RecordB, the from statement would read:

    From RecordB a
    Inner
    Join refAjustableRateIndicator d
    on d.Code = a.AdjustableInd

    Is that correct?

    Also since there are 4 other columns also in RecordB a, how would you added each next join? Does each one have it's own seperate join like this:

    From RecordB a
    Inner
    Join refAjustableRateIndicator d
    on d.Code = a.AdjustableInd
    Inner
    Join refAccruelBasis e
    on e.Code = a.AccrualBasis
    Inner
    Join refFloaterType f
    on f.Code = a.FloaterType
    Inner
    Join refFloaterRecordIndicator g
    on g.Code = a.FloaterRecordInd
    Inner
    Join refRateResetFrequency h
    on h.Code = a.ReateResetFrequency
    Last edited by ByGoneYrs; May 28th, 2013 at 03:14 PM.
  20. #11
  21. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,124
    Rep Power
    4274
    Originally Posted by ByGoneYrs
    Also since there are 4 other columns also in RecordB a, how would you added each next join? Does each one have it's own seperate join like this:
    yes

    go ahead and test it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  22. #12
  23. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    Ok ...LOL...after I fixed my own Typos....I got a error:

    mysql> SELECT a. AdjustableInd
    -> , a. AccrualBasis
    -> , a. FirstPaymentdate
    -> , a. FloaterType
    -> , a. FloaterRecordInd
    Join refAdjustableRateIndicator d
    -> , a. CurrentDeterminationDate
    Join refFloaterType f
    -> , a. CurrentResetEffectiveDate
    -> , a. RateResetFrequency
    -> , a. NextResetEffectiveDate
    -> , b. ResetDayOfMonth
    -> , b. ResetDayOfWeek
    -> , c. FormulaText
    -> , c. FormulaConditionHandlingCode
    -> From RecordB a
    -> Inner
    -> Join refAdjustableRateIndicator d
    -> on d.Code = a.AdjustableInd
    -> Inner
    -> Join refAccrualBasis e
    -> on e.Code = a.AccrualBasis
    -> Inner
    -> Join refFloaterType f
    -> on f.Code = a.FloaterType
    -> Inner
    -> Join refFloaterRecordIndicator g
    -> on g.Code = a.FloaterRecordInd
    -> Inner
    -> Join refRateResetFrequency h
    -> on h.Code = a.RateResetFrequency;
    ERROR 1054 (42S22): Unknown column 'b.ResetDayOfMonth' in 'field list'



    I did a show create table and the column is there for RecordFB b...


    | RecordFB | CREATE TABLE `RecordFB` (
    `SecurityID` varchar(12) NOT NULL,
    `RecordSequence` tinyint(4) NOT NULL,
    `ResetSequence` tinyint(4) default NULL,
    `ResetMethodEffectiveDate` date default NULL,
    `ResetFrequency` char(1) default NULL,
    `ResetFrequencyPeiod` smallint(6) default NULL,
    `ResetDayOfWeek` char(1) default NULL,
    `ResetDayOfMonth` char(1) default NULL,
    `ResetWeekOfMonth` char(1) default NULL,
    `MultipleFormulaHandlingCode` char(1) default NULL,
    `DetermineDaysPrior2ResetDate` smallint(6) default NULL,
    `DetermineDaysPrior2InterestDate` smallint(6) default NULL,
    `LastModifiedTime` datetime default NULL,
    PRIMARY KEY (`SecurityID`,`RecordSequence`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
  24. #13
  25. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,124
    Rep Power
    4274
    Originally Posted by ByGoneYrs
    mysql> SELECT a. AdjustableInd
    -> , a. AccrualBasis
    -> , a. FirstPaymentdate
    -> , a. FloaterType
    -> , a. FloaterRecordInd
    Join refAdjustableRateIndicator d
    -> , a. CurrentDeterminationDate
    Join refFloaterType f
    -> , a. CurrentResetEffectiveDate...
    wut?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  26. #14
  27. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    OK I tweeked the code and this is what I ended up with to get it to run...btw it took a long time...now instead of a Inner Join, would it be faster to do another join type to speed it up?

    SELECT a. AdjustableInd
    , a. AccrualBasis
    , a. FirstPaymentdate
    , a. FloaterType
    , a. FloaterRecordInd
    , a. CurrentDeterminationDate
    , a. CurrentResetEffectiveDate
    , a. RateResetFrequency
    , a. NextResetEffectiveDate
    , b. ResetDayOfMonth
    , b. ResetDayOfWeek
    , c. FormulaText
    , c. FormulaConditionHandlingCode
    From RecordB a
    Inner
    Join refAdjustableRateIndicator d
    on d.Code = a.AdjustableInd
    Inner
    Join refAccrualBasis e
    on e.Code = a.AccrualBasis
    Inner
    Join refFloaterType f
    on f.Code = a.FloaterType
    Inner
    Join refFloaterRecordIndicator g
    on g.Code = a.FloaterRecordInd
    Inner
    Join refRateResetFrequency h
    on h.Code = a.RateResetFrequency,
    RecordFB b, RecordF_FRNFormula c;
  28. #15
  29. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    Ok made a update and added some Security IDs to help speed this up, but it has been sudjested I do a Left Join instead of a Inner join? I am unsure which would honestly be better and why?

    SELECT a. AdjustableInd
    , a. AccrualBasis
    , a. FirstPaymentdate
    , a. FloaterType
    , a. FloaterRecordInd
    , a. CurrentDeterminationDate
    , a. CurrentResetEffectiveDate
    , a. RateResetFrequency
    , a. NextResetEffectiveDate
    , b. ResetDayOfMonth
    , b. ResetDayOfWeek
    , c. FormulaText
    , c. FormulaConditionHandlingCode
    From RecordB a
    Inner
    Join refAdjustableRateIndicator d
    on d.Code = a.AdjustableInd
    Inner
    Join refAccrualBasis e
    on e.Code = a.AccrualBasis
    Inner
    Join refFloaterType f
    on f.Code = a.FloaterType
    Inner
    Join refFloaterRecordIndicator g
    on g.Code = a.FloaterRecordInd
    Inner
    Join refRateResetFrequency h
    on h.Code = a.RateResetFrequency,
    RecordFB b, RecordF_FRNFormula c
    Where
    a.SecurityID =’02666QL27’
    and a.SecurityID = b.SecurityID
    and a.SecurityID = c.SecurityID;
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo