Incorrect Syntax near '='
Select Distinct Civilpartynames3.casenumber,civilpartynames3.partynamefull,civilpartynames3.ty,civilpartyn ames3.filing,civilpartynames3.cat,civilpartynames3.csid,civilattynames.attynm from civilpartynames3,civilattynames where civilpartynames3.casenumber = civilattynames.casenumber and civilattynames.attynm = 'FARLEY G HOLT,ESQ' AND Civilpartynames3.Filing = year(civilpartynames3.filing)= 2000 and month(civilpartynames3.filing)= 5
I know it has to do with the part with the first equal sign where it checks that the year equals 2000 but I dont know why .
I resolved the problem, thanks anyways . , I just had to remove the part that said "Civilpartynames3.filing = "
Last edited by Matrix.net; 03-28-2007 at 01:09 PM.
By shers in forum Database
Last Post: 06-17-2006, 05:01 AM
By kenn_rosie in forum .NET
Last Post: 04-09-2006, 09:28 PM
By Dan Barclay in forum .NET
Last Post: 08-12-2002, 11:06 PM
By Daryl in forum Database
Last Post: 03-01-2002, 02:08 PM
By Mario in forum Database
Last Post: 07-29-2000, 08:45 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL