I hope someone can help me with a syntax error I'm getting with a nested
query. I'm a newbie.
Here is the statement:
SELECT *
FROM tblmarkets
WHERE MarketID IN
(SELECT MarketID
FROM tblmarketproducts, tblproducts
WHERE tblmarketproducts.ProductID = tblproducts.ProductID AND
VALUES(2, 2);
INSERT INTO tblmarketproducts VALUES(2, 3);
INSERT INTO tblmarketproducts VALUES(4, 2);
commit;
~Wynne Crisman
-Original Message-
From: Eric Leupold [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 29, 2003 7:43 AM
To: [EMAIL PROTECTED]
Subject: Nested SQL QUERY
I hope someone
HI
MySQL does not support sub selects/nested queries :(
Peter
-Original Message-
From: Eric Leupold [mailto:[EMAIL PROTECTED]
Sent: 29 March 2003 16:43
To: [EMAIL PROTECTED]
Subject: Nested SQL QUERY
I hope someone can help me with a syntax error I'm getting with a nested
query. I'm