|
-
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.
Similar Threads
-
By shers in forum Database
Replies: 4
Last Post: 06-17-2006, 05:01 AM
-
By kenn_rosie in forum .NET
Replies: 5
Last Post: 04-09-2006, 09:28 PM
-
By Dan Barclay in forum .NET
Replies: 16
Last Post: 08-12-2002, 11:06 PM
-
By Daryl in forum Database
Replies: 0
Last Post: 03-01-2002, 02:08 PM
-
By Mario in forum Database
Replies: 2
Last Post: 07-29-2000, 08: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
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|
Reply With Quote
