How do I order by some of the rows in a column. Not all.

I have the following tables

PRODUCT_GROUP

ID (INT)*          'Example 1
NAME (VARCHAR)     'Example "Books"

PRODUCT
ID (INT)*          'Example: 1

ID (INT)*          'Example 1
NAME (VARCHAR)     'Example "Title"

PRODUCTID  (INT)*  'Example 1
PROPERTYID (INT)*  'Example 1
VALUE (VARCHAR)*   'Example "Learn SQL in 24 hours"

If I want to find books with titles like "SQL" I use the following query:

SELECT DISTINCT P.ID AS ID
FROM PRODUCT P, PRODUCT_PROPERTY PP
WHERE P.ID = PP.PRODUCTID
AND P.PRODUCTGROUPID = 1
AND PP.PROPERTYID = 1 AND UPPER(PP.VALUE) LIKE '%SQL%' My question is: How can I sort the result by the property "title".

Thanks for your help,

Jacob Received on Fri Oct 12 2001 - 16:22:33 CEST