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'
-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
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