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

From: Jacob Nordgren <jacob_nordgren_at_hotmail.com>
Date: 16 Oct 2001 01:50:08 -0700
Message-ID: <47c6b9be.0110160050.4228abb2_at_posting.google.com>


Thanks!!! / Jacob

marc_at_marcblum.de (Marc Blum) wrote in message news:<3bcb2b02.246444_at_news.online.de>...
> On 15 Oct 2001 07:23:05 -0700, jacob_nordgren_at_hotmail.com (Jacob
> Nordgren) wrote:
>
> >What if I want to search for another property (isbn) and still sort on
> >title? Is that possible with your query? I can't make it work..
> >
>
> SELECT /* DISTINCT */
> P.ID AS ID,
> PP_TITLE.VALUE as TITLE
> FROM PRODUCT P,
> PRODUCT_PROPERTY PP_TITLE,
> PRODUCT_PROPERTY PP_ISBN
> WHERE P.ID = PP_TITLE.PRODUCTID
> AND P.PRODUCTGROUPID = 1 --means Books
> AND PP_TITLE.PROPERTYID = 1 -- means Title
> AND PP_ISBN.PROPERTYID = 2 -- means ISBN
> AND UPPER(PP_ISBN.VALUE) LIKE '%123%'
> ORDER BY 2;
> regards
> Marc Blum
> mailto:marc_at_marcblum.de
> http://www.marcblum.de
Received on Tue Oct 16 2001 - 10:50:08 CEST

Original text of this message