podoc:view_users_subscribed_to_sql_view
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
podoc:view_users_subscribed_to_sql_view [2007/04/19 07:59] – Luud | podoc:view_users_subscribed_to_sql_view [2007/04/19 08:00] – Luud | ||
---|---|---|---|
Line 23: | Line 23: | ||
select client.identifier, | select client.identifier, | ||
from client, users, client_status | from client, users, client_status | ||
- | where client.users = users.identifier | + | where client.users = users.identifier |
- | and client.status = client_status.identifier | + | and client.status = client_status.identifier |
- | order by users.last_name, | + | order by users.last_name, |
</ | </ | ||
podoc/view_users_subscribed_to_sql_view.txt · Last modified: 2007/04/23 14:23 by Luud