I have 3 tables saleshead(pk-tranID,other fields +
trandate),salesdetails(fk-tranid) and payment(fk-tranid)..now i have 2
get all transaction from saleshead for a particular date
(trandate)..which is easy..but i also need to get all the rows from
salesdetails and payment based on tranid i get from saleshead for a
date..what are my options..joins,nested queries,using procedures..?
what i want is all this data i should be able to get in one trip to my
application..where i have fill 3 collections
thks