Hi
I'm trying to get some data fra a few tables, but I'm having a few
problems.
What I would like is this:
The tables contain somn info on manuscripts and which process that
manuascript has received.
a manuscript is represented once in manuascript table
that manuascript can have several records in the process table.
What I want is to get data for each manuscript and the last process that
the manuscript received from the process table.
This SQL gets the manuscript for each process it has received. SO if a
manuscript has 5 process records I will get 5 records back...
SELECT
Manuscript.m_id , Manuscript.uniq ueIDCountry,
Manuscript.uniq ueIDNo, Manuscript.m_ti tle,
Manuscript.coun try, Manuscript.m_re ceivedDate,
Process.p_id, Process.m_id, Process.process Date,
ProcessTypes.ps _id, ProcessTypes.pr ocessName
FROM
Manuscript,
Process,
ProcessTypes
WHERE [Process].m_id = [Manuscript].m_id
AND [Process].ps_id = [ProcessTypes].ps_id
Please help... I'm getting desperate..
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!