query help for displaying data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: query help for displaying data

  1. #1
    Join Date
    Mar 2004
    Posts
    52

    query help for displaying data

    I have a column called comments in table productsaudit where every time it logs when a user look for product description
    the comments will have like "looked by : james".I am stripping out the "looked by:" using ltrim so that i can get only
    james, which is a member from members table but the member full name can be in any one of the tables like user1 and
    user2 tables.user1 and user2 have different privilizes that's why we have two different tables and they have member column
    in each table

    I am trying to display something like (james(this is from product audit table -- jamesxyz(this can be from user1 or user2 table)
    .how do i do this, is this possibale.Can some one please help me.Anyhelp is much appreciated
    below is the strucutre of the table


    product audit
    --------------
    Productid number(10)
    productname varchar2
    productaudit varchar2(100)

    sample data for product audit
    ----------------------------------
    234- speakers- looked by :james
    435 -wirelessmouse- looked by :davis
    745 - keyboard -looked by :daniel

    user1
    ---------
    user1_1d number(2)
    user1fname varchar2
    user1lname varchar2
    member varchar2

    sample data
    ------------------
    121-james-xyz-james
    122-steve-abcd-steve


    user2
    ------
    user2_1d number(2)
    user2fname varchar2
    user2lname varchar2
    member varchar2

    Sample data
    -----------------------
    444 -davis-ghgh- davis
    445-daniel-dough-daniel

    members
    -------------
    memberid varchar2
    password varchar2

    sample data
    -----------------
    james-password1
    steve-password2
    davis-password3
    daniel-password4


    Thanks you

  2. #2
    Join Date
    Mar 2004
    Posts
    52
    any one???

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If only we knew what are you trying to say.....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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