Shouldnt there be a single = in the query? ac_log.month = 1..? Thanks and Regards, Sonal
On Mon, Mar 8, 2010 at 3:02 PM, prakash sejwani <[email protected]>wrote: > Hi all, > I have a query below > SELECT ip,dt,month,year FROM ac_log WHERE ac_log.month == 1 AND > ac_log.year == 2010; > when i run this query i get empty result out of it. Basically i want to > extract the data from a table whose month is 1 and year is 2010. > > Can anybody help me with this query > > thanks, > prakash > >
