RE: Out of memory on simple question.

2002-06-24 Thread Simon Green
Thanks for this... So I think I need some joins! Simon -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: 24 June 2002 12:19 To: Mysql (E-mail) Cc: Simon Green Subject: Re: Out of memory on simple question. * Simon Green After running this simple question I

Re: Out of memory on simple question.

2002-06-24 Thread Roger Baklund
* Simon Green After running this simple question I get this error. I have looked at the my.cnf file and all looks fine and the system has 1.256 G of memory. Can some one please tell me where I have gone wrong. select in_names.Username from in_names, in_names2 where in_names.Username !=