Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Unanswered: question

    respected sir,
    i have one table. it contains field ename,itemno,item1,quantity.
    i want to join table and want to gget resultsuch as ename,item,quantity.
    if i m using union all,then i get result . but i do not want to use union all.
    please give alternate query. reply soon plz.


    thanks and regards,
    dinesh kumar

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    First, your problem description is far from sufficient. So I have no clue what you want to join with what and which results you would like to have.

    Second, why don't you want to use UNION if it gives you the correct answer? The idea of SQL is that you specify "what" you want and the system figures out the best way "how" to get the result.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Dec 2008
    Posts
    5
    c'mon, that was funny, respected sir stolze.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I didn't mean to be funny at all.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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