ok, here are the 3 tables i have that are related:
mysql desc poll_questions;
++-+--+-++--
--+
| Field | Type| Null | Key | Default| Extra
|
Hi Darren,
On Tue, 5 Mar 2002 09:42:50 -0800
Daren Cotter [EMAIL PROTECTED] wrote:
mysql desc poll_questions;
++-+--+-++-
---+
| Field | Type| Null | Key | Default| Extra
|
To: [EMAIL PROTECTED]
Cc: Daren Cotter
Subject: Re: very tough query
Hi Darren,
On Tue, 5 Mar 2002 09:42:50 -0800
Daren Cotter [EMAIL PROTECTED] wrote:
mysql desc poll_questions;
++-+--+-++-
---+
| Field | Type
From: Daren Cotter [EMAIL PROTECTED]
...what happens when I want to delete a poll?
Do it machanically. That is, do a query in advance to find the data that needs to be
deleted, then go through and delete it. The logic for joining a delete can be written,
but MySQL doesn't support it. (Hey
PM
Subject: RE: very tough query
Here's what happens:
ERROR 1064: You have an error in your SQL syntax near ' poll_answers,
poll_votes where (poll_questions.poll_id = poll_answers.poll_id) ' at line 1
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05