OK I'm looking at this now. First glance is that it looks good. Not sure about the free bit though unless I have the wrong product, at:-
http://www.hkvstore.com/phpreportmaker/ Charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of HardyBoyz Sent: 28 May 2008 17:21 To: [email protected] Subject: Re: [php_mysql] Problem using joins Why don't you use phpreportmaker. it's free. you can join and grouping any table, and you don't need to typing the name of table and those field one by one, it's generated. Charlie Markwick <[EMAIL PROTECTED]> wrote: I have a group of tables and I am trying to display the details of a contact including their address, company address and the divisional address. I have listed the relevant part of the tables below. I am trying to use joins and I am very much a newbie at them. The selects I am creating do pass back data but they also produce duplicates and the duplicates do not necessarily have the correct address data. Can some kind person help me out of my misery? The select:- SELECT c.salutation, c.first_names, c.last_name, c.title, c.description, c.work_phone, c.email, addHome.address_name, addHome.address_body, addHome.line1, addHome.line2, addHome.city, addHome.postal_code, ltd.company_name, addBus.address_name, addBus.address_body, addBus.line1, addBus.line2, addBus.city, addBus.postal_code, div.division_name, addDiv.address_name, addDiv.address_body, addDiv.line1, addDiv.line2, addDiv.city, addDiv. ==============cut============= Yahoo! Groups Women of Curves Discuss food, fitness and weight loss. [Non-text portions of this message have been removed] ------------------------------------ The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links
