I have a fish databse. One table contains a Fish Database called FishDB. The other stores the fish per tank FishINV. So if I add three of the same type of fish I get three records in FISHINV records. I did it this way so I can add and remove fish and keep details about each fish. They may have the same ID but the comments about each one maybe different I am williing to remove this feature. My design may be fundamentally wrong but what I'm trying to do is query the FISHINV and get a count of each type.
This is the basic query I use: SELECT A.ID, B.CommonName FROM FISHINV AS A, FISHDB AS B WHERE TankId = 2 AND (A.FishID = B.ID); What can I add to count individual fish? Would it be better to keep a running count in a field instead ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
