Differences

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

--- podoc:view_contact_sql_view [2007/04/13 07:36] – Luud
+++ podoc:view_contact_sql_view [2007/04/20 15:40] (current) – Luud
@@ Line 11: / Line 11: @@
 === Schema ===
-  create view view_contact as
+<code sql>
-    select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status
+create view view_contact as
-      from client, users, client_status
+  select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status
-     where client.client = users.identifier
+    from client, users, client_status
-       and client.status = client_status.identifier
+   where client.client = users.identifier
-     order by users.last_name, users.first_name;
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>
 === Related tables ===
@@ Line 23: / Line 25: @@
   * [[client_status sql table|client_status]]
   * [[users sql table|users]]
-=== Related indexes ===
-=== Related functions ===
-=== Related views ===
 === History ===
@@ Line 44: / Line 40: @@
 = Version 2.5 =
-  create view view_contact as
+<code sql>
-    select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status
+create view view_contact as
-      from client, users, client_status
+  select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status
-     where client.client = users.identifier
+    from client, users, client_status
-       and client.status = client_status.identifier
+   where client.client = users.identifier
-     order by users.last_name, users.first_name;
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>