Re: Multi Table Join

In <DBAv5E.1sF_at_on.bell.ca> galigian_at_on.bell.ca writes:

>select a.name, b.date,b.hours,c.expenses
>from a,b,c
>where a.name = b.name
>and a.name = c.name
 

>How can I get a multi table join to not
>return duplicate rows of information?

Add the word DISTINCT after the 'select' as in:

    select DISTINCT a.name, ....

---
John