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.Userna

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 questio

Out of memory on simple question.

2002-06-24 Thread Simon Green
Hi 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 != in_names2.Username