Re: [sqlite] Help with query

Without testing on my side... how's that? select a.Shop1, a.Shop2, a.Postcode, b.Code, b.Shopname, b.Address1, b.Price from NewsData a, Agents b where (a.Shop1 > '' or a.Shop2 > '') and b.Shopname > '' and (a.Shop1 = b.Shopname or a.Shop2 = b.Shopname) order by a.Postcode asc On Fri, 8 Oct 2004

Re: [sqlite] SQL help

Well, isn't the point of the HAVING clause? SELECT MAX(A), B FROM T GROUP BY B HAVING B=5 Fred