Re: Select from two tables not returning the expected number of rows - Ted Byrne - com.mysql.lists.mysql

6 messages in com.mysql.lists.mysqlRe: Select from two tables not return...

From	Sent On	Attachments
Ted Byrne	12 Oct 2004 18:44
Philippe Poelvoorde	13 Oct 2004 01:38
Ted Byrne	13 Oct 2004 05:58
SGr...@unimin.com	13 Oct 2004 07:12
Ted Byrne	13 Oct 2004 07:59
Philippe Poelvoorde	13 Oct 2004 08:30

Subject:	Re: Select from two tables not returning the expected number of rows
From:	Ted Byrne (ted....@adelphia.net)
Date:	10/13/2004 07:59:12 AM
List:	com.mysql.lists.mysql

You didn't even say that (svr, started, ended, volume, who, action) was a unique combination of values for either table. If that is the case then you will have a hard time matching rows of one table uniquely to rows of the other table.

Shawn,

Sorry for the lack of clarity on my part. The combination should be unique for each of the tables, and there should be one record in table_b having the same combination as the each record in table_a.

It is looking like there are duplicated rows, and I'm going to have to get them cleaned out.

Thanks for your assistance,

Ted