I have a database with three tables: Header Transactions Nominals ------ ------------ --------
record_id record_id record_id advice_note item nominal_code date quantity nominal_cost input_by price would it be better to use three separate select queries based on the same record_id for each, or one select query with INNER JOINs? If I use the single query with the INNER JOINs and it all gets sucked into an ArrayCollection, how to I filter it so that I can put all the transactions into one dataGrid and, say, all the nominal stuff into another? As you can tell, my experience is limited in database use. When I have used databases for web related work they have been of the simple, flat, flavor.
