Member Avatar for y_itay

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

  • 1 Contributor
  • 1 Reply
  • 71 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by y_itay
Member Avatar for y_itay

I think I got it.
thank anyway :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.