Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Join to find rows not in second table
Brilliant, works like a bought one. Thanks for that, your're a champ. -
Join to find rows not in second table
Hi, I'm trying to write a SELECT for MySQL 4.0 using a JOIN. I can get it to work in v4.1 using a subquery, but my ISP provides v4.0 only. I've got 2 tables: - group: Describes groups that exist, key is group_id - usergroup: Members of groups - has user_id and group_id I want to find which... -
Using Pass by Reference Functions
I'm converting some Visual Basic GUI programs into VBScript command line tools to test the availability of remote application servers. I'm having trouble getting VBScript to handle a function that includes 3 'pass by reference' arguments, which the function updates with return information. The...
