yoda man.. again...
So, help me learn ? pretty please... ?
I need to say, optionId = 1 AND (4 or 6 or 6) .... etc...
I get how you've redone the latest aset version call, nice one..
I don't understand whats happening at teh bottom of the query..
can you dumb it down for me?
Whee do you live? anywhere beerable?
On 04/12/06, r937 <[EMAIL PROTECTED]> wrote:
select asset.id
, asset.naturalName
, assetVersion.fileName
, assetVersion.fileNameThumb
, assetVersion.dateCreated
, assetVersion.size
, asset.assetVersionId
from asset
inner
join assetVersion
on assetVersion.assetId = asset.id
on assetVersion.versionNumber =
( select max(versionNumber)
from assetVersion
where assetId = asset.id )
inner
join assetPropertyOption
on assetPropertyOption.assetId = asset.id
and assetPropertyOption.optionId
in ( 2, 8, 12 )
group
by asset.id
, asset.naturalName
, assetVersion.fileName
, assetVersion.fileNameThumb
, assetVersion.dateCreated
, assetVersion.size
, asset.assetVersionId
having sum(case when assetPropertyOption.optionId = 2
then 1 else 0 end ) = 1
and sum(case when assetPropertyOption.optionId in ( 8, 12 )
then 1 else 0 end ) > 0
donations to my paypal account gratefully accepted
;o)
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to $subst('List.Name') as:
$subst('Recip.EmailAddr')
To unsubscribe send a blank email to $subst('Email.UnSub')
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
