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
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
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.batch_id,
query that joins the b table with the d
table should solve your problem.
Hope this helps you further.
Best Regards,
Jan.
-Original Message-
From: Jonas Lindén [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 11:57 AM
To: [EMAIL PROTECTED]
Subject: Select statement returning
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, b.creator, b.comments FROM cd_batch as b;
But when I add this table