So below is my SQL query, but when I add the client.name it pulls every client in the system instead of just the one that has the one account i'm searching for in it. Is there a way to join one table to another to show me just the client's name on that one account?
Select
DCGI.Client...