First I dont know if this is the proper way to go about this so feel free to berate me if I am braking some fundemental rule.
I have reference a query inside of another query and joined it to a table.
When I run the query, It returns the same records over and over.
But when I try the join manually (copying a value in the joined table and then filtering the refernced query with it) it gives me only one record like I expected.
Why does it return the same record (every field is the same) over and over again?
I have reference a query inside of another query and joined it to a table.
When I run the query, It returns the same records over and over.
But when I try the join manually (copying a value in the joined table and then filtering the refernced query with it) it gives me only one record like I expected.
Why does it return the same record (every field is the same) over and over again?