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 . :SICK:
I resolved the problem, thanks anyways . :D , I just had to remove the part that said "Civilpartynames3.filing = "