I would like to purge my DB of users that don't have links. Here is a SQL query that will list the ID's of linkowners, but I can't seem to get one working that will find (or better yet, delete) the opposite of this...
SELECT ID FROM DB_Links, DB_Users WHERE DB_Links.LinkOwner = DB_Users.Username
Any thoughts? I saw a post from pugdog a while back that addressed this issue using the addition of a user_num_links column, but I'm not good enough at SQL to figure out the holes in the code to make it work.
Best Regards
SELECT ID FROM DB_Links, DB_Users WHERE DB_Links.LinkOwner = DB_Users.Username
Any thoughts? I saw a post from pugdog a while back that addressed this issue using the addition of a user_num_links column, but I'm not good enough at SQL to figure out the holes in the code to make it work.
Best Regards