RE: [SQL] Need SQL Help Finding Current Status of members

Good point. I have a deadline to meet which is why I "cheated" so I'll have
to get back to it later.

Thanks.

> -----Original Message-----
> From: Michael Fuhr [mailto:mike@fuhr.org]
> Sent: Sunday, December 18, 2005 9:19 PM
> To: Michael Avila
> Cc: SQL PostgreSQL MailList
> Subject: Re: [SQL] Need SQL Help Finding Current Status of members
>
>
> On Sat, Dec 17, 2005 at 07:34:22PM -0500, Michael Avila wrote:
> > The table is not empty. I did some playing around with the SQL
> Statement but
> > got no where. So I added a record status column that will be
> non-NULL when
> > the status becomes history because a new status is added. Yeah,
> I cheated to
> > make it easy!! LOL But it now works and that is what counts!
>
> Even if you're satisfied with whatever you ended up doing, it might
> still be educational to find out why the query didn't work. If you
> post a test case we'll take a look; we might even be able to suggest
> a better solution than the "cheat" you used.
>
> --
> Michael Fuhr


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org