From 39081f84a402aebb52d98a43e4675c90135cea9b Mon Sep 17 00:00:00 2001 From: Alexander Sulfrian Date: Wed, 7 Dec 2011 19:06:52 +0100 Subject: added sql files --- sql/server_delete_get_qa_clients.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/server_delete_get_qa_clients.sql (limited to 'sql/server_delete_get_qa_clients.sql') diff --git a/sql/server_delete_get_qa_clients.sql b/sql/server_delete_get_qa_clients.sql new file mode 100644 index 0000000..bc7b983 --- /dev/null +++ b/sql/server_delete_get_qa_clients.sql @@ -0,0 +1 @@ +SELECT clients.client_id FROM group_server_to_client, clients WHERE group_server_to_client.id1 = clients.client_id and clients.server_id=:server_id: and group_server_to_client.server_id=0; \ No newline at end of file -- cgit v1.2.3