DAL Filter Functions by Foreign Key

Database Connections

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

SELECT    BuildingID, BuildingName, SiteID
FROM      Buildings
WHERE     (SiteID = @siteid)
SELECT    LocationID, LocationEasyName, LocationTypeID, BuildingID
FROM      Locations
WHERE     (BuildingID = @buildingid)
SELECT    LocationID, LocationEasyName, LocationTypeID, BuildingID
FROM      Locations
WHERE     (LocationTypeID = @locationtypeid)

Well done.

Database Connections