thanks for that Berend, Yes I agree the code I am working with is very old :(
select e.id,es.attribute from person e INNER JOIN table2 es on es.person_id = e.id, WHERE es.attibute = 'Blender' I am wanting to create multiple joins on the table2 (attribute) table so that can find people who have multiple attributes... ie: Find people who have attribute 'blender' and attribute 'driver' with each attribute existing as a row in table2. On Thu, Aug 12, 2010 at 9:51 AM, Berend de Boer <[email protected]> wrote: >>>>>> "Brendan" == Brendan Brink <[email protected]> writes: > > Brendan> Could you advise if you can see any issue / fix with the > Brendan> queries i have recently been making? > > Can you first please write this with ansi join style? Your syntax has > been obsolete for 25 years. > > After that it's much easier to spot problems. > > -- > Cheers, > > Berend de Boer > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] -- Kind Regards, Brendan Brink SMS Marketing Consultant | Manager Sell2Cell Ltd. 021 0246 1646 | [email protected] | www.sell2cell.co.nz We provide customized, cost-effective SMS & Web Solutions Need a website? Need to integrate text-messaging into your business or website? Contact us today for a free no-obligation quote! VISIT OUR ASSOCIATED WEBSITES: textvouchers.com | textguru.co.nz WARNING This email contains information which is CONFIDENTIAL and may be subject to LEGAL PRIVILEGE. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy the email or attachments. If you have received this in error, please notify us immediately by return email, facsimile, or telephone (call us collect). -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
