DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Query doubt

  1. #1
    Join Date
    Feb 2003
    Location
    india
    Posts
    1

    Question Query doubt

    I have one master table and a detail table. How can I get all the rows in the detail table for a perticular key in the master table int o a single row. For Eg

    Master
    -------
    key date
    1 1-jan-03


    detail
    ------
    key date desc
    1 1-jan-03 description1
    1 1-jan-03 description2



    The result should be
    ------------------------------------
    1 1-jan-03 description1 description2



    Thanks in advance
    Santhosh

  2. #2
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110
    select a.field1,a.field2,b.field1,b.filed2
    from master a,detail b
    where a.key(+)=b.key

    More over if u have enforced the foreign key relation from detail to master(ie Master deatils relation) thsi kind of scenarion wont be happen but vice versa..

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