I am trying to put write a view for multiple tables but have minimal experience in writing views. Can you provide a template that I can work off?
Here is what I am trying to accomplish....
There are 8 tables involved:
I need to write a view to display the following information:
type_id (table 6 and 3)
type (in tables 6 and 7)
description - of entities associated with type (table 7)
their id ranges start (table 2)
their id ranges end (table 2)
hostnames (if any)(table 2)
host_id( table 3)
I will need to use the deliverable date in Table_3 to show only those that are current.
Thanks for help.