Member Avatar for noob2008

Hi ppl ,

Need some advise on my SQL coding .

i have written some SQL code to draw and compare some data in which i was thrown back with an error of no Select statement after <> or any other expression .

Can someone advise me of any walkaround in which i can get my code to work as seen in the logic below ?

CODE :

Select SYS.Netbios_Name0, SYS.Resource_Domain_OR_Workgr0, SF.FileName, SF.FileDescription,
SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath
from v_GS_SoftwareFile SF
join v_R_System SYS on SF.ResourceID = SYS.ResourceID
WHERE SYS.Netbios_Name0 Like @variable and SF.FileName <> (Select FileName from v_GS_SoftwareFile where ResourceID = '3060' )
Order by SF.FileName

Note : The problem come at this statement "(Select FileName from v_GS_SoftwareFile where ResourceID = '3060' )"

Kindly Advise thanks .

Edited by noob2008 because: n/a
  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.