Another possible solution (although more drastic) is to switch DBMS's. I
use PostgreSQL with no troubles. However, 6.5 and earlier are not so
great performance wise. 7.0.3 is OK, and 7.1.2 is exceptional. It also
now (finally) supports outer joins and write ahead locking.
If you are at the be
At 3:10 PM +0100 8/9/01, Dave Watkinson wrote:
>You'll note that both step requires a return, which general means a
>subquery, I believe for MySQL to hanle subqueries you actually have
>to perform to separate queries. If your not using MySQL then you
>could write a statement such as:
>
>SELECT
thanks for that ... I've made some comments within yours...
Your getting a lot of errors, because the statement has well a lot of
mistakes. Let's start near the beginning, you state:
SELECT empid, COUNT(empid) FROM emp_cont , employers, contacts
This statement should produce an error,
At 12:52 PM +0100 8/9/01, Dave Watkinson wrote:
>
>I have (many many many) tables ... two of which are linked by a third,
>so that there can be a one-to-many relationship. What I'd like to do is
>find which ids from table 1 have more than one relation in table 2, via
>table 3.
>
>I've tried this..
"Dave Watkinson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
PS This is for a web page, so it's PHP related!!! :-)
-Original Message-
From: Dave Watkinson
Sent: 09 August 2001 12:51
To: PHP-DB List (E-mail)
Subjec
PS This is for a web page, so it's PHP related!!! :-)
-Original Message-
From: Dave Watkinson
Sent: 09 August 2001 12:51
To: PHP-DB List (E-mail)
Subject: [PHP-DB] Another SELECTING problem :-(
I've a feeling I've asked this before, but checked my old messages and
cou
I've a feeling I've asked this before, but checked my old messages and
couldn't see it in there for the excess of non PHP-Database questions
flying around (yep - that's a joke, but I've been here a while - forgive
me!).
I have (many many many) tables ... two of which are linked by a third,
so th
