Fairly new to MYSQL, still learning.
I have create basic web databases before but the project i am working on just now is slightly more complex than before and need some advice.
i have had some help qith queries which has been great however i need some advice from you guys.
Basically in the database there is multiple product tables as the criteria in the tables are different from each other.
In my app i need to display info for these products, whether that be how many products sold in total or more complicated data like how much due in this week.
what are your guys thoughts on me using a product table that has a relationhip between all the 25 indivdual product tables and the users table to get data onto my web app?
i would appreciate any advice.