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
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
Dear Jamie,
try a JOIN (LEFT JOIN I would suppose for your problem). Read the MySQL
manual chapter 7 (look for the join syntax there). It is something like
SELECT * FROM table1 LEFT JOIN table2 ON (table1.id = table2.id)
Regards,
Stefan Hinz (Geschäftsleitung)
iConnect e-commerce solutions
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
Are you looking for:
SELECT table1.name, table2.subject
FROM table1, table2
WHERE table1.id=table2.student_id
Good Luck,
Dennis
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
