Hello,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make only one query ...
I've got a list of users
And also a login table
I would like to list all users and show the number of times they have
logged in.
So to get the list of users I would do :
SELECT username, first_name, last_name FROM user_list
And to count the number of connections I would do
SELECT COUNT(*) AS count FROM login_table WHERE username =
$result['username']
Can I do something like this :
SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS count
FROM login_table b WHERE a.username = b.username) FROM user_list a
I know that the above query can not work but It's just to give a better
idea about what I'm trying to do . :)
If I do a join, I will the username repeated for each login.
Thanks in advance,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]