I have a SQL question:
Does anyone know how to do this:
DELETE FROM table1 USERID, FNAME, LNAME, table2.TEAMID WHERE table1.USERID=table2.USERID AND LastRosterChangeDate < todaysdate.
THe kicker is that the application is based in EASTERN timezone, and the server located in CENTRAL. SO i have time offset I have to deal with as well.
THe application is a sports team database, and the players can remove themselves from a team at anytime, however I only want them to remove themselves from the eventDate IF todays date has not passed the LastRosterChangeDate (and take into account the 3 hour time difference in my server)
Hope that wasnt too confusing!