This select gives me the number of times a given element appears on
each of the watch lists owned by user 2;
SELECT COUNT(watch_list_id), element_id
FROM watch_list WL, watch_list_element WLE
WHERE WL.user_id = 2
AND WL.id = WLE.watch_list_id
GROUP BY WLE.element_id;
This que
Title: Default Permissions (repost from Novice)
How can I set default permissions on tables, so that I don't have to manually set them for every table?
p.s.
This is a re-post from the novice list, I thought it might also be appropriate to ask here.
MIKE WEAVER
Software Developer
5, 42 Lad
