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
* 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 t
-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
* 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
