User Profile

Collapse

Profile Sidebar

Collapse
nikolap
nikolap
Last Activity: Nov 16 '06, 06:32 PM
Joined: Aug 7 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nikolap
    replied to Need help adding 3rd table to a Join
    in SQL Server
    Nevermind my brain came back to life, I have answered my own question...
    CREATE View mProduct_Search

    As

    Select

    mProduct.*,

    (IsNull(mProduc t.PRICE,0) * 2) as [DISPLAY_PRICE],

    (IsNull(mProduc t.LINER_PRICE,0 ) * 2) as [DISPLAY_LINER_P RICE],

    (mProduct.ITEM_ ID + ' ' +IsNull(mProduc t.[SHORT_DESCRIPTI ON],' ') + ' ' + IsNull(mProduct .[CAT_PG],' ') + ' '+ IsNull(mProduct .[CATEG],'...
    See more | Go to post

      Leave a comment:

    • nikolap
      replied to Need help adding 3rd table to a Join
      in SQL Server
      I need the COLLECTION field from the mCollection Table to be included in the mProduct_Search view
      See more | Go to post

        Leave a comment:

      • nikolap
        started a topic Need help adding 3rd table to a Join
        in SQL Server

        Need help adding 3rd table to a Join

        Hi can someone help me I'm brainless, I need to add a field from a third database to this view

        CREATE View mProduct_Search

        As

        Select

        mProduct.*,

        (IsNull(mProduc t.PRICE,0) * 2) as [DISPLAY_PRICE],

        (IsNull(mProduc t.LINER_PRICE,0 ) * 2) as [DISPLAY_LINER_P RICE],

        (mProduct.ITEM_ ID + ' ' +IsNull(mProduc t.[SHORT_DESCRIPTI ON],' ') + ' ' + IsNull(mProduct .[CAT_PG],'...
        See more | Go to post
        No activity results to display
        Show More
        Working...