This is a very truncated version of what I am trying to do:
Code:
SELECT t1.JID, t1.JDESC, t1.CreateDate, t1.JSTATUS, t1.LastMod,
wm_concat(t7.JSTATUS_USERID) JSTATUS_USERID,
wm_concat(t7.JSTATUS_HISTORY) JSTATUS_HISTORY,
wm_concat(t7.EnteredDate) EnteredDate, t5.APP_VER, t6.APP_MFG
FROM table1 t1
LEFT OUTER JOIN table2 t2 ON t2.JID = t1.JID
LEFT OUTER JOIN table3 t3 ON t3.WID = t2.WID
LEFT OUTER JOIN table4 t4 ON t4.UID = t1.UID
LEFT OUTER JOIN table5 t5 ON t5.SID = t4.SID
LEFT OUTER JOIN table6 t6 ON t6.MID = t5.MID
LEFT OUTER JOIN table7 t7 ON t7.SNID = t5.SNID
LEFT OUTER JOIN table8 t8 ON t8.JID = t1.JID
LEFT OUTER JOIN table9 t9 ON t9.JID = t1.JID AND t9.UTYPE = 'C'
WHERE t1.JID = ' one long a$$ string '
Thank you, again.
__________________
^_^
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".
Last edited by WolfShade; 12-07-2012 at 08:25 PM..
|