I need to develop scripts to generate a few tables that are combined from other tables. I have a table containing providers and a table containing locations.
Test 1, John 826D3EB6-4198-4202-8B5A-B4541BE0F2F7
Test 2, Jane AE3D195E-DF03-4C92-A5FD-8E02B438E318
Tester, Jim 6AA0CA8F-B8AF-4B3D-87B0-FDD5BF35F096
Anderson Internal Medicine 14BC4AB9-6A8F-497E-B5CB-37C7BAE1AB66
Baptist Medical Center B9C4053D-A87E-494B-AA68-37EBC26C6894
Christian Children's Hospital 4CFAB23F-40AF-4E65-9832-757B0D93D0B6
Memorial Hospital C7326B3F-ED69-4065-B077-DC8E2D7B5D05
I'm looking to possibly curse through and develop scripts to create new tables that look similar to the attached. The document column will be hard coded with a value.
I am basically looking for a table generating script that can be made with all locations for one provider, all providers with one location, and one with all locations and all providers. Hopefully that makes sense.