It doesn't work because MySQL version 3.23.50 does not support sub-select
statement.
http://dev.mysql.com/doc/mysql/en/subqueries.html
And
How to re-write it in MySQL < 4.1
http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html
Nandar wrote on Monday, 19 September 2005 1:03 PM:
> i hope
Hi,
Aleks Kalynovych wrote:
> I have a couple forms that generate a unique ID based on taking
> the highest
> number in the ID column adding 1 to its value. The problem is that I
> donât save that number until the form is submitted. If 2 or more
> persons fill out
> the form at the same time they
Hi,
I don't think you can do that with MS SQL, it doesn't support TRASFORN, I
think that's strictly Access syntax. MS SQL 7 and up does have ROLLUP etc
but that's part of the OLAP service, which you will only get if you have
Enterprise edition (read $$ :)).
The easiest way to get out of this
