- Original Message -
From: "Daniel Brockhaus" <[EMAIL PROTECTED]>
To: "Jeff Dyer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 4:43 PM
Subject: Re: subquery syntax
> Wouldn't
>
> SELECT Contac
Wouldn't
SELECT Contacts.FirstName, Contacts.LastName FROM Contacts, Users WHERE
Users.UserName = 'Doug' AND
Users.UserPassword = 'Crock' AND
Contacts.ContactId = Users.ContactId;
work?
Daniel
At 16:28 30.07.02 +0100, you wrote:
>Forget it (at least for the forseeable future)
>
>Th
Is the idea, then, to string queries together, the result of one
feeding the next?
Thanks
David
On Tuesday, July 30, 2002, at 11:28 AM, Jeff Dyer wrote:
> Forget it (at least for the forseeable future)
>
> This is the well known MySQL feature that means that MySQL is not even
> SQL
> compati
Try this:
SELECT Contacts.FirstName, Contacts.LastName FROM Users,Contacts WHERE
Contacts.ContactId = Users.ContactId AND Users.UserName = 'Doug'
AND Users.UserPassword = 'Crock');
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 10:56
Forget it (at least for the forseeable future)
This is the well known MySQL feature that means that MySQL is not even SQL
compatible. Argg. Apparently you will have to wait for version 4.1.
Subqueries are not supported
Jeff
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[
