I have several tables (Interfaces, Circuits) which contain information such as (Interfaces.ID, Interfaces.Rate, Interfaces.Region) and (Circuits.CircuitID, Circuits.IntA, Circuits.IntB, Circuits.Speed) where Circuits.IntA = Interfaces.ID and relates to an entry and Circuits.IntB = Interfaces.ID and relates to an entry. Essentially there are 2 entries in Interfaces for every CircuitID - an IntA and IntB.
Problem: How do I search where I can put in a Region and pull all results listed as such:
Region(1)
CircuitID, Speed
Circuits.IntA Interfaces.Rate Interfaces.Region(1)
Circuits.IntB Interfaces.Rate Interfaces.Region(x)
Essentially, I need to use a value from a query result to perform a second query.
THANK YOU!!!!
Problem: How do I search where I can put in a Region and pull all results listed as such:
Region(1)
CircuitID, Speed
Circuits.IntA Interfaces.Rate Interfaces.Region(1)
Circuits.IntB Interfaces.Rate Interfaces.Region(x)
Essentially, I need to use a value from a query result to perform a second query.
THANK YOU!!!!