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 t
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
[EMAIL PROTECTED] wrote:
Hi!
I have a problem that may only be solvable using a programming approach, but
I'm wondering if there is an SQL method in MySQL.
The problem is that I have a table that looks like this:
CREATE TABLE `test` ( `uid` mediumint(6) NOT NULL auto_increment,
On Sat, 20 Nov 2004 19:14:55 -0800
<[EMAIL PROTECTED]> wrote:
> they have the same perid, program and startdate. I would very much like
> to get a listing for each perid that shows their perid, program, startdate
> and then the latest (only the latest) stopdate. This would give unique
SELECT pe
Hi!
I have a problem that may only be solvable using a programming approach, but
I'm wondering if there is an SQL method in MySQL.
The problem is that I have a table that looks like this:
CREATE TABLE `test` ( `uid` mediumint(6) NOT NULL auto_increment,
`perid` varchar(10) default NULL, `pro
> Hi all,
>
> Is there anyway to delete the duplicate records in mysql
> without creating new tables. I am wondering what query
> will achieve this task where mysql doesnt supports like ROWID and
> sub queries.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0
/ Carsten
--
Carsten H. Pedersen
k
Hi all,
Is there anyway to delete the duplicate records in mysql
without creating new tables. I am wondering what query
will achieve this task where mysql doesnt supports like ROWID and sub queries.
I appreciate if some one help me out.
thankyou.
-malkova.
-
