How can I do MySQL works fine with this simple query:

SELECT DISTINCT User_ID,(SELECT Count(User_ID) FROM users p1 WHERE
p1.User_ID = users.User_ID) AS CountID
FROM users

MySQL don't have subselect capabilities, so....

We're using 4.0.12 version in Win2K3 server...

Thanx
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to