Sorry about the multiple posts. I waited hours for the others to go through
and they didn't, then all at once.
That worked GREAT! Thank you very much. However, I don't really see any
differences from my attempts and yours except that you did the joins on the
FROM and I did it on the WHERE. Is that the major difference?
Also, I substituted:
On a.passport_listing_id = d.passport_listing_id
and (a.student_id = d.student_id or a.people_id = d.people_id)
for
On a.passport_listing_id = d.passport_listing_id
and a.s_uid = d.s_uid
I put in s_uid for that purpose. The student_id and people_id are often used
differently but the same here so I have s_uid as a field where they co-exists.
dunno if it's a good idea, but it has made things simpler.
If you have any education for me on why yours worked, I'd like it. Otherwise -
THANK YOU VERY VERY MUCH.
daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327800
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
