I'm new to the SQL family of products and was hoping someone could help me create a query that will:
1. gather EF data: get start and end times, durations, parent EFs and any EF attributes + values (we have a hierarchy for unit procedure, operation and phase and only phase level has attributes/values)
2. grab referenced unit name
3. grab the archived values (timestamp and value) for all attributes of the referenced unit during the phase level of the EFs
I see there are some example and built-in queries in the SQL Commander Lite. I know how to do step 1 on it's own and step 3 on it's own but I'm having trouble getting all 3 steps into one query. I would appreciate any help!