All pastes #16077 Raw Edit

lug

public sql v1 · immutable
#16077 ·published 2005-06-28 13:23 UTC
rendered paste body
			SELECT 		user_data.user_id, last_name			FROM 		user_data						LEFT JOIN 	user_access			ON		user_access.user_id = user_data.user_id						LEFT JOIN 	access_keys			ON 		access_keys.key_id = user_access.key_id						WHERE		user_access.user_id IS NULL			OR		access_keys.name <> 'LTD'						GROUP BY 	user_data.user_id