I know I know ;-p So.. I tried to adda region filter, which is in a table jsut liek the option select.. assetRegion: assetId regionId
Using this: (but if I search for more than one region, I get nothing, searching for ONE region, I get correct results.. :-( ) It looks the SAME to me!!! WAAAAA :-( ======================== SELECT asset.id, asset.naturalName, assetVersion.fileName, assetVersion.fileNameThumb, assetVersion.dateCreated, assetVersion.size, asset.assetVersionId, MAX( assetVersion.versionNumber ) FROM asset INNER JOIN assetVersion ON assetVersion.assetId = asset.id AND assetVersion.versionNumber = asset.assetVersionId INNER JOIN assetPropertyOption ON assetPropertyOption.assetId = asset.id AND assetPropertyOption.optionId IN ( 1, 6, 7 ) INNER JOIN assetregion ON assetregion.assetId = asset.id AND assetregion.regionId IN ( 1, 2, 3 ) GROUP BY asset.id, asset.naturalName, assetVersion.fileName, assetVersion.fileNameThumb, assetVersion.dateCreated, assetVersion.size, asset.assetVersionId HAVING sum( CASE WHEN assetPropertyOption.optionId =1 THEN 1 ELSE 0 END ) =1 AND sum( CASE WHEN assetregion.regionId IN ( 1, 2, 3 ) THEN 1 ELSE 0 END ) > 0 AND sum( CASE WHEN assetPropertyOption.optionId IN ( 6, 7 ) THEN 1 ELSE 0 END ) > 0 On 04/12/06, r937 <[EMAIL PROTECTED]> wrote:
> One things that frustrates me, is how am I supposed to figure this > stuffout on my own without someone in the know to hand hold me :-( practice, practice, practice! ;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: wdvltalk@lists.wdvl.com 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: wdvltalk@lists.wdvl.com 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.