Hello,
When trying to do a large select statement like the following this error
is returned:
select account.username,person.firstname,person.lastname,
person.company_name, person.street,person.city,person.state,
person.zip,person.franchise,
person.card_number,person.expires,account.date, transaction.*
from person,account left join transaction
on account.username=transaction.username
where (account.id=person.id)
&& ((account.day>='1') &&(account.day<='24')
&&(account.type!='franchise')
&&(person.pay_method='ccard'))
order by person.franchise,account.username;
I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help
and now I'm out of ideas. Any suggestions would be appreciated.
Griff Hamlin, III
Quik International.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
