Re: select statement

simply try: select info.name, address.phone, count(info.id) from info, OUTER address whereinfo.name=address.name group by info.name this is informix notation only. > Hi! > > I have two tables: One with customer related information and one with > customer addresses. > I want to list the number of entries that every customer has in the > first table so what I did is: > > select info.name, address.phone, count(info.id) from info, address where> info.name=address.name group by info.name