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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center