I was wondering if someone can help me work out a SELECT statement that's driving me crazy. First the databases I have and want to cross join:
friends - userID
- friendID
users - userID
- username
- firstname
- lastname
What I would like to do is get all friendID's who are linked to $userID inside the friends DB...along with that get the firstname and lastname from the users DB and match them up with all the friendID's I got previously. Then output a result like this:
friendID, username, firstname, lastname.
friends - userID
- friendID
users - userID
- username
- firstname
- lastname
What I would like to do is get all friendID's who are linked to $userID inside the friends DB...along with that get the firstname and lastname from the users DB and match them up with all the friendID's I got previously. Then output a result like this:
friendID, username, firstname, lastname.