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