Question: Single query or multiple queries
I am developing a web-based application for my friend for a process that uses an Excel sheet currently.
I have attached the Excel sheet for reference.
I have created the database structure as under:
I want to know the optimal way of writing a query to display the excel sheet structure in the web-based application.
I have written a query, but for each "step" the "check_text" is repeated.
I need help in how to query in a way such that I can display the exact structure of the excel sheet.
Hope somebody can help!!
Other tips are welcome too :)
Thanks and Regards