This content has been marked as final. Show 3 replies
Here you go, This also gets e-mail, office Phone Number
vndt.office_phone as attendee_phone,
vndt.mobile_phone as attendee_mobile,
vndt.mail_address as attendee_e_mail
WHERE mmat.attendee_vendor_ini = vndt.initials
mmat.attendee_vendor = vnmt.vendor_abbrev
vndt.parent_key = vnmt.master_key and
vnmt.project_name= :vendor_type and
((vnmt.project_name = :vendor_type) and
( mmat.parent_key = :master_key ))
ORDER BY mmat.attendee_name
Wow. That worked great.
I would have been here all day thinking about it and still probably wouldnt have gotten it.
Thank you very much for the help.