I am having a bit of time with a lab I am doing for school when I write the query this way there is no problems, it does what I want it to do. (I have tried to edit this to give the right formatting but it just is not working)
propertyState = 'NY'
however, when I am answering the question to do that same query but using join instead of a sub I get an error.
View Complete Post