>OPPS... > >Change the on a.student_id = d.student_id to on a.passport_listing_id = >d.passport_listing_id
That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on passport_listing_id) 2 - my original join that was working except i couldn't integrate the passport_attendance_id. 3 - the join that you gave me. It returns way too many entries. It should be 26 like #2, but with passport_attendance_id inserted where it exists and null where it does not. I'm hoping that by seeing the data, it'll be clear if I have not explained it well. btw, thanks for the assistance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4