Assuming that the lastest ID is the same as the current name - maybe something
like :
select * from sometab t1
where id=(
select max(id) from sometab t2 where t1.code=t2.code
)
On Thursday 13 July 2006 10:16, Helen M Hudson wrote:
> If I have a table
> primary key id | code
If I have a table
primary key id | code| name
1 | ABC | company 1 name
2 | ABC | company 1 name
3 | ABC | new company 1 name
4 | ABC | new company 1 na
eitung)
iConnect e-commerce solutions GmbH
www.iConnect.de - www.js-webShop.de
TEL +49 30 46307-382 - FAX -388
---
- Original Message -
From: Jamie Burns <[EMAIL PROTECTED]>
To: Dennis Salguero <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 11:48
solutions GmbH
www.iConnect.de - www.js-webShop.de
TEL +49 30 46307-382 - FAX -388
---
- Original Message -
From: Jamie Burns <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 11:25 PM
Subject: quickie!
hi..
can someone tell me how i get the data from two t
t me trying to make things too efficient...
jamie.
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Jamie Burns" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 10:32 PM
Subject: Re: quickie!
> Are you
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 2:25 PM
Subject: quickie!
hi..
can someone tell me how i get the data from two tables, where table1 will
have one row, and table2 will have many rows?
eg:
table1:
idname
hi..
can someone tell me how i get the data from two tables, where table1 will have one
row, and table2 will have many rows?
eg:
table1:
idname
1barney
2fred
3wilma
table2:
idstudent_id subject
11
