SQL Help

Question

I have a simple working sql script I wrote and want to fine tune it to days of week, or even between certain dates. Ive tried everything and am stumped at this point. The column I think I should be using says its ambiguous when I add it, so I think I'm missing syntax. Can anyone help please.

This works, now I just need to tune it for days, or dates.

SELECT
Client_SSID,
Client_Status,
Controller_Name,
Client_Name
FROM NPM_NV_WL_CLIENTS, NPM_NV_WL_CONTROLLERS
WHERE Client_Status = 'blank' AND Client_SSID = 'blank' AND Client_Name = 'blank'
GROUP BY Client_SSID, Client_Status, Controller_Name, Client_Name

Thanks in advance!

kindbro · Accepted Answer

Figured it out. Had to add the table names before my columns. Working like a charm now.