[ cf-dev ] same table different day...

[Stephen Moretti]

I wrote a query :

SELECT Product.Name,Desc_SHORT.DescText AS ShortText,Desc_LONG.DescText 
AS LongText
FROM Product
   LEFT JOIN Descriptions ON Product.ID = Descriptions.ProductID
      LEFT JOIN Description AS Desc_SHORT
        ON (Descriptions.DescriptionID = Desc_SHORT.ID AND 
Desc_SHORT.type = 'short')
      LEFT JOIN Description AS Desc_LONG
        ON (Descriptions.DescriptionID = Desc_LONG AND Desc_LONG.type = 
'long'

in the hope that I would get :

Name ShortText LongText

what I actually get is

Name ShortText  {nowt}
Name {nowt} LongText
I've tinkered with different JOIN types, but don't seem to be getting 
the right combination to get the intended output.

Any suggestions would be most welcome.

Stephen

--
These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
     *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
          *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]