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
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
couldn't see
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)
Subject: [PHP-DB] Another SELECTING
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...
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 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
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
