Daniel Kessler wrote .. > > Any advice on how to approach this is appreciated. >
Change it to a LEFT JOIN, which will always pull in the data from the repair_ticket table, and return NULL in the columns from people_alt if there is no match... <CFQUERY NAME="getSelect" DATASOURCE="dpch"> SELECT a.repair_ticket_id,a.date_added,a.fname,a.lname,a.department,a.fix_days, a.time_of_day,a.technician,a.technician_fname,a.technician_lname,a.status,a.severity,a ...description,a.issue_type,a.platform,a.hardware_type,a.model,a.make,a.operating_syste m,p.location AS technician_location,p.email AS technician_email,p.phone AS technician_phone FROM repair_ticket a LEFT JOIN people_alt p ON a.people_alt_id = a.technician WHERE a.repair_ticket_id = #id# </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
