All pastes #16845 Raw Edit

lugzer

public sql v1 · immutable
#16845 ·published 2005-07-04 14:25 UTC
rendered paste body
SELECT 	order_id, lunch_orders.user_id, lunch_orders.cat_id, lunch_order, price, paid,	first_name, last_name, office, 	lunch_catering.name AS cat_nameFROM 	lunch_orders			LEFT JOIN 	user_data USING 		(user_id)		LEFT JOIN 	lunch_catering ON		lunch_catering.cat_id = lunch_orders.cat_id			WHERE 		(user_data.office = 1 OR user_data.office = 2)	GROUP BY 	cat_id