Leakyradiator
Technical User
I have a database that is not normalized. It consists of categories and organizations. In some cases, where an organization is in several categories, all the organization information is repeated for each category, in some instances as often as 8 times.
The categories come from a categories table and the organizations come from a organization table, with the category ID's used as a foreign key.
What SQL code can I use to pull the organization name from the database and each of the categories that apply to it so that I can then dump it into a normalized database?
Thanks
The categories come from a categories table and the organizations come from a organization table, with the category ID's used as a foreign key.
What SQL code can I use to pull the organization name from the database and each of the categories that apply to it so that I can then dump it into a normalized database?
Thanks