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!
Thanks f
On Fri, Dec 16, 2005 at 07:44:46PM -0500, Michael Avila wrote:
> Just tried it and it returned nothing.
>
> > > Select * from memberstatus A where not exists
> > >(select * from emberstatus B where B.member_id=A.member_id and
> > > B.status_date >A.status_date)
>
> Why the WHERE NOT EXISTS?
On Fri, Dec 16, 2005 at 14:03:14 -0200,
Alexandre Gonçalves Jacarandá <[EMAIL PROTECTED]> wrote:
> Guys, I can do what I need but I have other problem: How can I named
> columns with another data ? For example:
You might be better off doing this in your application rather than entirely
with sql.
