I have just moved over to a new job and been given the task of trying to
sort out historic client databases (MS-Access). I have exported
everything to CSV, then into MySQL 5.0.15 no problems at all. However
due to the way the original system was developed i have so much
duplicated data it is
Subqueries.
select * from ClientJune2005 where customerCode = (select customercode
from ClientAug2005);
http://dev.mysql.com/doc/refman/4.1/en/subqueries.html
=C=
|
| Cal Evans
| http://www.calevans.com
|
VaioLord wrote:
I have just moved over to a new job and been given the task of trying