Hey guys,

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 :/

10 Years
Discussion Span
Last Post by y_itay
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.