SQL Help

[kindbro]

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!

[njoylif]

first you need to find out what columns in those 2 tables have dates in them and ensure they are in the context you are looking for, i.e. client status change @ x time. 

then you want to use that/those columns in reporting.

i.e. append your WHERE clause to include your requirements.  See/download THIS POST and THIS POST for examples

[kindbro]

Thanks njoylif, but I'm still confused. I have the column identified that I want to use where a date is located, but it still does not work. I'm using a column from table NPM_NV_WL_APS column LastUpdate and can not extrapolate the info from it. I get an ambiguous error on LastUpdate.

[kindbro · Accepted solution]

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

[njoylif]

awesome, glad to hear.  Great Job.