* compuserve aka Bill Stennett
I have the following situation:
the DB has three tables 'users', 'links' and 'searches'. Each table has a
common key named 'userid'
This does not match the table/column names you describe below... are you
trying to confuse us? ;)
What I want to do is, for each
-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
* Bill - compuserve
Thanks for the suggestion but unfortunately this seems to produce the
product of the two tables `lghyperlink` and `lgsearch`.
Yes, sorry about that.
[...]
Any other suggestions gratefully received - maybe this has to be
done in two queries and the data manipulated in the
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