Why won't this work?

Results 1 to 2 of 2

Thread: Why won't this work?

  1. #1
    Join Date
    Dec 1969

    Default Why won't this work?

    select distinct a.firstname,a.lastname<BR>from groupleaders as a,usertracking as b<BR>where a.employeenumber&#060;&#062;b.employeenumber and datepart(day,b.dateaccessed)=datepart(day,getdate( ))and datepart(month,b.dateaccessed)<BR>= datepart(month,getdate())and datepart(year,b.dateaccessed)= datepart(year,getdate())<BR><BR>It returns everything

  2. #2
    .. Guest

    Default RE: Why won't this work?

    I may be wrong, but I don&#039;t believe you can use &#060;&#062; in SQL....<BR>You should use NOT LIKE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts