i'm trying to join 3 tables. tables 1 and 2 contain information about a
person, table 3 contains reviews of that person and may not have any
data. outer join, right? i can't get it to work though.
the tricky part is i don't want to return the actual data from the 3rd
table, i just want the
AFAIK, the problem is in the Group statement. You can't count on the
grouped field. You need to group by ad.id and then use group functions
(max(name) etc... to get the info, and count on review...
That's how I would do it.
--Brian
On Fri, 14 Dec 2001, Jon Drukman wrote:
i'm trying to join