MYSQL query problem.

Ok heres the deal.

I have two tables

TableK -
user
user2

TableU
user
username

current Query

SELECT k.user, p.username, k.user1, count(k.user1)
FROM TableU AS P, TableK as K
WHERE k.user = p.user
GROUP BY k.user, p.username, k.user1
ORDER BY count(k.user1)

Code (markup):

i want to also be able to see user1's username.

i just cant seem to figure it out. Any help would be appreciated

~thanks

 

I would format this query like this:

SELECT k.user, k.user1, count(k.user1) AS count, p.username  
FROM TableU AS p LEFT JOIN TableK as k
ON p.user = k.user
GROUP BY k.user, p.username, k.user1
ORDER BY count(k.user1)

Code (markup):

I'm not sure about your GROUP BY clause. You may need to mess with it to get this to work properly.

 

Note taken,

im willing to try anything The things i need to be displayed are

User1's username
User2's username
the count of User2