who can solve this.
Posted by:
Andreas
Date: August 10, 2005 01:14AM
i need help solving this.
I have three tables
one is called online
one is called friend
one is called users
online looks like this:
---------------------------------
ident | username | ident_user
1________nisse_________1
2________chris_________2
3_______ david_________3
friend looks like this
---------------------------------
ident | ident_user | ident_friend
1__________1___________2
2__________1___________3
members looks like this:
---------------------------------
ident | username | password |
1______nisse______nisse
2______chris______chris
3______david______david
now to what i want..
I want to select all the users that are online
and are my friends.
Subject
Written By
Posted
who can solve this.
August 10, 2005 01:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.