Hello,
I have a large sql query I need to write and am having some problems with
it. I have broken it down into several sections...the fist section I cannot
figue out involves 3 table which I have listed below along with the main
fields I need to deal with in parenthasis:
tblContacts
(pk_uniqueID, CMAppt)
tblCasacCM
(pk_CMAppt, pk_CasacAppt)
tblCasac
(pk_CasacAppt, CasacDate)
In the tblCasac, there are many pk_CasacAppt's that relate to only one
CMAppt. I need to capture the most recent pk_CasacAppt(using CasacDate) for
a particular CMAppt.
Hope this all makes sense,,,any suggestions would be greatly appreciated...
TIA,
Julie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
