hi i have a table
I need to (create new/update) following result table.
For every aa I should have three entries ie aa, ab and ac. Similarly for every bb I should have 2 entries like bb and ba and cc should have four entries like cc,ca,cb and cd and so on. And these extra entries will remain constant like for aa resulting table will have 3, for bb it will have 2 and for cc it will be 4 etc Rest of the values in table will not change so my resulting table becomes
I would be really appreciate if some one could tell me about how should i approach this ... thank you in advance ....
asked Sep 24 '12 at 07:04 PM in Default
You could do a join between the two tables to get the results, then you can put it in another table or create a view as needed.
It would look something like:
answered Sep 24 '12 at 08:48 PM