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]
