On 04-Apr-2003 [EMAIL PROTECTED] wrote: > Hi there, > > I have some experience with SQL, but I'm drawing a blank on this one. I > have a table with these fields: > > Location > Unit > StartDate > StopDate > > I want to construct a SELECT statement to get to a report that looks > something like this: > > Location1 Location2 Location3 ... > Date1 count of units where Datex is between > Date2 StartDate and StopDate ... > Date3 > ... > > Where Date1, Date2, etc are a week apart within a given date range. > > Any help appreciated. >
<A HREF="http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html";> Cross-tabulation<A> Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
