All pastes #16841 Raw Edit

lugzer

public sql v1 · immutable
#16841 ·published 2005-07-04 13:44 UTC
rendered paste body
SELECT 	lunch_orders.user_id, lunch_orders.cat_id, lunch_order, price, paid,					first_name, last_name, office, name					FROM 	lunch_orders				LEFT JOIN user_data USING (user_id)	LEFT JOIN lunch_catering USING (cat_id)				WHERE 		(user_data.office = 1 OR user_data.office = 2)		ORDER BY 	user_data.office	AND 		user_data.last_name