select count from three tables

2004-01-21 Thread compuserve
Hi All I have the following situation: the DB has three tables 'users', 'links' and 'searches'. Each table has a common key named 'userid' What I want to do is, for each user in the 'lguser' table I'd like to count the number of corresponding records in EACH of the 'lghyperlink' and 'lgsearch'

RE: select count from three tables

2004-01-21 Thread Bill - compuserve
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 16:51 To: [EMAIL PROTECTED] Cc: compuserve Subject: Re: select count from three tables * compuserve aka Bill Stennett I have the following situation: the DB has three tables 'users', 'links

RE: select count from three tables

2004-01-21 Thread Bill - compuserve
thanks for taking the time to look best bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 20:19 To: [EMAIL PROTECTED] Cc: Bill - compuserve Subject: Re: select count from three tables * Bill - compuserve Thanks for the suggestion