Complex Query

I have a couple tables, i.e

table one
fielda
fieldb
fieldc

table two
fielda
fieldd

I need to be able to count the number of 'd's in table two and display along with the query from table one, something like:

select fielda,fieldb,fieldc, sum(fieldd) from one a, two b where a.fielda=b.fielda

Anyone know how I'd so this? Should the sum(fieldd) be a view? Received on Thu Mar 20 2003 - 11:11:02 CST