[SQL] how to use a date range in a join

[chester c young]

trying to do something like

select     d.day,
           c.name
from       [dates between day1 and day2] d
left join  c.some_table;

but cannot figure out what to put into the brackets.




 
____________________________________________________________________________________
Finding fabulous fares is fun.  
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel 
bargains.
http://farechase.yahoo.com/promo-generic-14795097

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly