Results 1 to 2 of 2

Thread: Self Join in SQL - SQL database

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    CREATE TABLE #WorkingData
    (
    receipt_id int
    ,receipt_item_id int
    ,fulfillment_type_id int
    ,created_dt smalldatetime
    )

    INSERT INTO #WorkingData
    (order_id
    ,item_id
    ,vendor_id
    ,created_dt)
    (SELECT order_id, item_id, vendor_id, created_dt
    FROM database1.dbo.vw_table
    WHERE created_dt < dateadd(mi, -61, getdate())
    AND vendor_id IN (0, 15, -1000, -1015))


    SELECT Distinct wd.order_id, wd.item_id, wd.vendor_id, w.vendor_id, wd.created_dt
    FROM #WorkingData wd
    JOIN #WorkingData w
    ON wd.item_id = w.item_id
    --WHERE w.vendor_id IN (0, 15)

    I am trying to get a result back that will give me

    order_id, item_id, vendor_id (positive number), vendor_id (negative number), created_dt

    Help.

    I need to do a self join?

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    at the beginning i made an error it should be vendor_id not fulfillment_type_id

    thxs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width