Michelle Streeter wrote:If you read what I said, that one was the original. I then later changed the structure of B to better reflect what was in the real issue and then I posted what was generated in the second set of code for C.
Michelle Streeter wrote:
BTW, I didnt design the original tables and so I have to live with their design. A references a Scenario. B references a resource, C references schedule items. So, you pick a scenario then you pick a resource to see the scheduled items for that scenario and resource.
Below are the table structures
A:
id int Unchecked
name nchar(10) Checked
B:
id int Unchecked
Aid int Unchecked
Bid int Unchecked
name nchar(10) Checked
C:
id int Unchecked
Aid int Unchecked
Bid int Unchecked
name nchar(10) Checked
sunglasses are a type of coolness prosthetic. Check out the sunglasses on this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
|