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 - 03:50:08 CDT
