Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.ClaimNumber, a.ItemDate, c.DTN, b.FilePath
- FROM items a,
- itempages b,
- keygroupdata c
- WHERE a.ItemType IN (112,115,189,241)
- AND a.ItemNum = b.ItemNum
- AND b.ItemNum = c.ItemNum
- ORDER BY a.DateStored DESC
- SELECT c.ClaimNumber, a.ItemDate, c.DTN, b.FilePath
- FROM items a
- INNER JOIN itempages b ON b.ItemNum = a.ItemNum
- INNER JOIN keygroupdata c ON c.ItemNum = b.ItemNum
- WHERE a.ItemType IN (112,115,189,241)
- ORDER BY a.DateStored DESC
- select
- c.claimnumber,
- a.itemdate,
- c.dtn,
- b.filepath
- from
- (
- select itemdate
- from items it
- where it.itemtype in(112,115,189,241)
- ) a
- itempages b,
- keygroupdata c
- where a.itemnum = b.itemnum
- and b.itemnum = c.itemnum
- SELECT /*+RULE*/
- c.ClaimNumber, a.ItemDate, c.DTN, b.FilePath
- FROM
- items a,
- itempages b,
- keygroupdata c
- WHERE a.ItemType IN (112,115,189,241)
- AND a.ItemNum = b.ItemNum
- AND b.ItemNum = c.ItemNum
- ORDER BY a.DateStored DESC
- SELECT c.ClaimNumber, a.ItemDate, c.DTN, b.FilePath
- FROM items a,
- itempages b,
- keygroupdata c
- WHERE ((a.ItemType IN ('112','115','189','241'))
- AND (a.ItemNum = b.ItemNum)
- AND (b.ItemNum = c.ItemNum))
- ORDER BY a.DateStored DESC
- with a as (
- select
- *
- from
- items
- where
- ItemType IN (112,115,189,241)
- )
- SELECT
- c.ClaimNumber
- , a.ItemDate
- , c.DTN, b.FilePath
- FROM
- a,
- itempages b,
- keygroupdata c
- WHERE
- a.ItemNum = b.ItemNum
- AND b.ItemNum = c.ItemNum
- ORDER BY
- a.DateStored DESC
Add Comment
Please, Sign In to add comment