persistentstorage/sql/TEST/contacts_startup_time.sql
author Chris Dudding <chris.dudding@nokia.com>
Tue, 13 Jul 2010 18:32:07 +0100
changeset 37 5ce4638b3d6d
parent 0 08ec8eefde2f
permissions -rw-r--r--
DEADHEAD Closing redundant branch: Bug 3168 (changeset 32: 0bacd7dbb9a9) is already incorporated in the 201025_05 bulk delivery (changeset 33: 5e4beccba4e9).
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
08ec8eefde2f Revision: 201003
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff changeset
     1
SELECT cm_firstname, cm_lastname, parent_cmid 
08ec8eefde2f Revision: 201003
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff changeset
     2
FROM identitytable 
08ec8eefde2f Revision: 201003
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff changeset
     3
WHERE cm_type=268440329
08ec8eefde2f Revision: 201003
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff changeset
     4
ORDER BY cm_firstname, cm_lastname;