[thelist] SQL Question - 'Contingent Columns'

[rudy]

> Sorry it wasn't clear - I'll try again:

getting clearer...

> I need a way to put things back together.

what database engine?  do you have scripting?  temp tables?

will CURRENT_DATE - 1 DAY get the correct "yesterday" to match the date
table?

(i am not so much concerned with time zones, i figure whole dates is what
you want, right?)


rudy

p.s madhu the enforcer is in india, whereas i am in toronto

... or why else did you mention toronto time?