Michael T. Tangorre wrote:
> Hey everyone.
>
> I have a database with 2 tables that I am dealing with.
> Table resumes
> Table seekers
>
> The resumes table can hold more than one resume for a person, and each
> is unique by the resume_ID
>
> Suppose there are 2 records in the database with the same value in a non
> key column but I wanted the one with the higher ID...
SELECT *
FROM resumes
WHERE resumes.id IN (SELECT Max(id)
FROM resumes
WHERE fill_out_the_rest_yourself)
Jochem
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
