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 revision Previous revision
podoc:view_users_subscribed_to_sql_view [2007/04/19 04:00]
Luud
podoc:view_users_subscribed_to_sql_view [2007/04/23 10:23] (current)
Luud
Line 19: Line 19:
 === Schema === === Schema ===
  
-<​code>​+<​code ​sql>
 create view view_users_subscribed_to as create view view_users_subscribed_to as
   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
Line 48: Line 48:
 = Version 2.5 = = Version 2.5 =
  
-<​code>​+<​code ​sql>
 create view view_users_subscribed_to as create view view_users_subscribed_to as
   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
podoc/view_users_subscribed_to_sql_view.txt ยท Last modified: 2007/04/23 10:23 by Luud