-
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 12:09 PM.
Similar Threads
-
By shers in forum Database
Replies: 4
Last Post: 06-17-2006, 04:01 AM
-
By kenn_rosie in forum .NET
Replies: 5
Last Post: 04-09-2006, 08:28 PM
-
By Dan Barclay in forum .NET
Replies: 16
Last Post: 08-12-2002, 10:06 PM
-
By Daryl in forum Database
Replies: 0
Last Post: 03-01-2002, 01:08 PM
-
By Mario in forum Database
Replies: 2
Last Post: 07-29-2000, 07:45 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
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
|
Reply With Quote
Bookmarks