Less columns the better and good design
Hi,
I would even suggest you make it lesser than 52 column, It would be even easier for you have data and rows added as per dates (or week no and year). The data retrieval could be based on your date range. You may end up with more data than your previous one with (52 column design), but will be easier and efficient with good design.
HTH,
Giri
kolanupaka
Last Activity: Dec 1 '08, 07:42 AM
Joined: Oct 29 '08
Location:
-
Thanks Coolsti,
This is something similar that I was looking for, but unfortunately neither tab2no nor tab1no are unique in my case. But later I realized that this need not be done my join at all, this can be done by simply using two tables in inserting itself and using SUM with group by table1.tab1no. Thanks for the help.
Regards,
Kolanupaka...Leave a comment:
-
Complex join?
All,
I am novice in SQL/MySQL. I need a query to join two tables say table1 and table2. But the join should happen not based on PK, but based on other columns, which are non-unique. One of the columns joined in table2 is sum of all the numbers in a column, when the clause is satisfied. For example here are the tables:
table1:
tab1id, tab1no, tab1name,tab1va l
1,'01','one',10 0
2,'01','two',20 0
10,'02','ten',3 00...
No activity results to display
Leave a comment: