SQL query - 07/28/2004 9:38 PM
I'd like to find out the SQL commands to get the following information:
a) Login name
b) User name (as shown on forums)
c) Registered on
d) Total Posts
e) Last On
f) Real email
on the specific groups.
Like i have a reg members group, admin group, guest group. etc.
Could I get all this info (a-f) on 1 command for each group? If so, what would the syntax be. Also is there any online reference for SQL query syntax that I could look up so i don't have to bother you poor folks?
thanks!
a) Login name
b) User name (as shown on forums)
c) Registered on
d) Total Posts
e) Last On
f) Real email
on the specific groups.
Like i have a reg members group, admin group, guest group. etc.
Could I get all this info (a-f) on 1 command for each group? If so, what would the syntax be. Also is there any online reference for SQL query syntax that I could look up so i don't have to bother you poor folks?
thanks!