I have some question about a query in SQL I'm buliding for my software.
This software meant for Bills managing.
I have main screen which display all the bills and another screen which display
the bill details, this screen built on 3 tables : Bill,BillItem,Payment tables.
My question is should I create 1 query for the display bill screen? or should I create 3 queries, one for the bill details, one for the payment tables, and one for the items.
What is more correct to do? I'm not sure about that one :/