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

put order by title at the end.
Jim
"Jacob Nordgren" <jacob_nordgren_at_hotmail.com> wrote in message news:47c6b9be.0110120622.57febc70_at_posting.google.com...
> Hi,
>
> I have the following tables
>
> PRODUCT_GROUP
> ID (INT)* 'Example 1
> NAME (VARCHAR) 'Example "Books"
>
> PRODUCT
> ID (INT)* 'Example: 1
> PRODUCTGROUPID (INT) 'Example: 1
>
> PROPERTY
> ID (INT)* 'Example 1
> NAME (VARCHAR) 'Example "Title"
>
> PRODUCT_PROPERTY
> 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:31:18 CEST