At 12:43 +0100 4/15/04, zzapper wrote:
Here's another rotter!
I searched UseNet and read that in MySQL you cannot have a sub-select,
That's old information. Subqueries are supported as of MySQL 4.1.
You'll probably need some quotes around the values in your BETWEEN
expression, though.
but I'm
Here's another rotter!
I searched UseNet and read that in MySQL you cannot have a sub-select,
but I'm lost as to how to split this into two selects?
SELECT distinct p.ProjectID ,p.ProjectName FROM tbl_project AS p
INNER JOIN
(
(
(tbl_UnitType AS ut INNER JOIN tbl_RateType AS r ON
Hi,
I've moved a Database Application from MSAccess to Mysql, most of the
application seems to work fine, but I'm having trouble with Inner
Joins. (The scripting language is ColdFusion MX 6.1) mySql 4.018.
Any help desperately welcome, including explanation of the principles
SELECT i.*,
You need to drop the parenthesis. It looks you are trying to do a join
on a sub-join, and you appear to be missing a join condition. Or you're
trying to create a join with multiple conditions, which if fine. Near
as I can tell, you've made this a lot more complicated than it should.
I'm not
On Wed, 14 Apr 2004 16:59:31 -0400, wrote:
You need to drop the parenthesis. It looks you are trying to do a join
on a sub-join, and you appear to be missing a join condition. Or you're
trying to create a join with multiple conditions, which if fine. Near
as I can tell, you've made this a lot