I shoudl really learn myself.. let me paly, and if still can;'t get it, I'll be back on Monday.. with more info...
Cheers for your help though!!! On 20/10/06, r937 <[EMAIL PROTECTED]> wrote:
> I tried that, but it caused an error... then you added it in the wrong place, and unfortunately my crystal ball is not working at the moment, so you will have to post the query >>> try it without DISTINCT > > Cause duplicated galore! which simply shows that your joins are wrong >>> this is called a "cross join effect" > > Yes.. but I've got a filter in place, so it's all good... well, if you like slow queries and clogged bandwidth, sure rudy ____ � 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.
