Jan 212012
 

Here is the start of a query for pulling out travel requirements for conference attendees.

SELECT P.last_name, P.first_name,
       CPT.arrival_from,
       CPT.arrival_to,
       CPT.need_accommodation
  FROM conference_person_travel CPT, conference_person CP, conference C, person P
 WHERE CPT.need_accommodation
   AND CPT.conference_person_id = CP.conference_person_id
   AND P.person_id              = CP.person_id
   AND CP.conference_id         = C.conference_id
   AND C.acronym                = 'BSDCan2012'

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>