asked on
Simple SQL Joining Query Issue
Ok so I have a FK constraint, from tblMeetingRoom to tblFacility, the Primary intFacilityID in tblFacility is a FK in tblMeetingRoom as facilityId. However I am having issues with getting the data I want from tblFacility; I'm not quite sure what I am missing from the SQL syntax but I am sure someone will set me straight.
![Query]()
So you can see how I am trying to get the data from chrFacilityName within tblFacilty by using the relationship betweent intFacilityID and facilityId. However the query doesnt return the correct result. So what syntax do I need or what change to the query do I need to make.
In summary: I want a list of DISTINCT chrFacilityNames WHERE intFacilityID = facilityId
So you can see how I am trying to get the data from chrFacilityName within tblFacilty by using the relationship betweent intFacilityID and facilityId. However the query doesnt return the correct result. So what syntax do I need or what change to the query do I need to make.
In summary: I want a list of DISTINCT chrFacilityNames WHERE intFacilityID = facilityId
Microsoft SQL Server
Last Comment
piemckay
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thats perfect, just put the DISTINCT clause in too! Awesome thanks!