4 Replies Latest reply on Sep 15, 2011 11:54 AM by njoylif

    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!