User Tools

Site Tools


podoc:view_users_subscribed_to_sql_view

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
podoc:view_users_subscribed_to_sql_view [2007/04/19 07:59] Luudpodoc:view_users_subscribed_to_sql_view [2007/04/19 08:00] Luud
Line 23: Line 23:
   select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status   select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status
     from client, users, client_status     from client, users, client_status
-   where client.users = users.identifier           -- only select users that have clients +   where client.users = users.identifier 
-     and client.status = client_status.identifier  -- only select valid status values +     and client.status = client_status.identifier 
-   order by users.last_name, users.first_name;     -- sort on last_name, first_name+   order by users.last_name, users.first_name;
 </code> </code>
  
podoc/view_users_subscribed_to_sql_view.txt · Last modified: 2007/04/23 14:23 by Luud