Nested SQL statements are not supported except in insert statements in
MySQL (4.1 may include this feature, if not seems scheduled to be
included soon). You can accomplish this query using an inner join.
SELECT m.*
FROM tblmarkets m
INNER JOIN tblmarketproducts mp ON mp.MarketID = m.MarketID
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