Differences

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

--- podoc:view_contact_sql_view [2007/04/12 12:23] – created Luud
+++ podoc:view_contact_sql_view [2007/04/20 15:40] (current) – Luud
@@ Line 1: / Line 1: @@
-===== Database View Description =====
+===== Database View Description of "view_contact" =====
 === Name ===
+view_contact
 === Description ===
@@ Line 9: / Line 11: @@
 === Schema ===
-=== Related tables===
+<code sql>
+create view view_contact as
+  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
+   where client.client = users.identifier
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>
-=== Related sequences ===
+=== Related tables ===
-=== Related indexes ===
+  * [[client sql table|client]]
+  * [[client_status sql table|client_status]]
-=== Related functions ===
+  * [[users sql table|users]]
 === History ===
@@ Line 31: / Line 40: @@
 = Version 2.5 =
-  create view ... (
+<code sql>
-    ...
+create view view_contact as
-  );
+  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
+   where client.client = users.identifier
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>