Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unanswered: Select Statement

    Please help me with this query.

    I have two tables and the data in them as shown below.

    create table vin_comm_dd_party (
    dd_id number (15),
    party_id number (15),
    party_type varchar2(12)
    );


    create table vin_comm_party (
    party_id number (15),
    party_nm varchar2(100)
    );


    insert into vin_comm_dd_party values (123451,1,'gtee1');
    insert into vin_comm_dd_party values (123451,2,'gtor1');
    insert into vin_comm_dd_party values (123451,3,'gtee2');
    insert into vin_comm_dd_party values (123451,4,'gtor2');

    insert into vin_comm_party values (1,'gtee1 name');
    insert into vin_comm_party values (2,'gtor1 name');
    insert into vin_comm_party values (3,'gtee2 name');
    insert into vin_comm_party values (4,'gtor2 name');

    My Desired output is

    123451 1 gtee1 name 2 gtor1 name 3 gtee2 name 4 gtor2 name

    How do I achieve this?

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    select dd_id, d.party_id, party_nm
    from vin_comm_dd_party d, vin_comm_party v
    where d.party_id = v.party_id;
    Regards,
    Julia

Posting Permissions

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