Re: Select statement returning to many answers

2004-05-24 Thread Jonas Lindén
onday, May 24, 2004 12:16 PM Subject: Re: Select statement returning to many answers > Jonas Lind?n <[EMAIL PROTECTED]> wrote: > > Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this > > query I get 153 hits. > > > >SELECT b.batch_id, b.date

RE: Select statement returning to many answers

2004-05-24 Thread Jan Goyvaerts \(jgoyvaer\)
AIL PROTECTED] Subject: Select statement returning to many answers Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this query I get 153 hits. SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b; But when I add this table to the where clause i get 5831 hits

Re: Select statement returning to many answers

2004-05-24 Thread Victoria Reznichenko
Jonas Lind?n <[EMAIL PROTECTED]> wrote: > Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this > query I get 153 hits. > >SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b; > > But when I add this table to the where clause i get 5831 hits > >SELECT b.

Re: Select statement returning to many answers

2004-05-24 Thread Neculai Macarie
> Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this > query I get 153 hits. > > SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b; > > But when I add this table to the where clause i get 5831 hits > > SELECT b.batch_id, b.date, b.creator, b.comments F

Select statement returning to many answers

2004-05-24 Thread Jonas Lindén
Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this query I get 153 hits. SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b; But when I add this table to the where clause i get 5831 hits SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch