RE: JOIN and Table Full error

2001-12-13 Thread Almar van Pel
- Van: Mayo, Chuck [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 13, 2001 04.11 Aan: '[EMAIL PROTECTED]' Onderwerp: JOIN and Table Full error Hi all, I'm pretty new with MySQL and am trying to implement my first join. All works as expected until I try to order the output with an order

RE: JOIN and Table Full error

2001-12-13 Thread Mayo, Chuck
| | +---+--+--+-++-- --+ 48 rows in set (0.00 sec) -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:33 AM To: Mayo, Chuck Cc: [EMAIL PROTECTED] Subject: RE: JOIN and Table Full error Hi, Your setting tmp_table_size is probably

JOIN and Table Full error

2001-12-12 Thread Mayo, Chuck
Hi all, I'm pretty new with MySQL and am trying to implement my first join. All works as expected until I try to order the output with an order by clause; select * from Players,Roster where Roster.playerId=Players.id order by Players.plast limit 1,10 and I receive an error from the MySQL