for the help.
Mike
> -Original Message-
> From: Michael Fuhr [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 17, 2005 7:26 PM
> To: Michael Avila
> Cc: SQL PostgreSQL MailList
> Subject: Re: [SQL] Need SQL Help Finding Current Status of members
>
>
> On
LECT * FROM memberstatus A WHERE NOT EXISTS (SELECT * from
memberstatus B WHERE B.member_id=A.member_id AND B.status_date >
A.status_date)";
Mike
> -Original Message-
> From: Michael Avila [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 16, 2005 8:46 AM
> To: SQL Pos
Re: [SQL] Need SQL Help Finding Current Status of members
>
>
> Richard Huxton wrote:
>
> > Michael Avila wrote:
> >
> >> I have a table which keeps track of the status of members. In the
> >> table is
> >>
> >> member_id int(8)
> >
I have a table which keeps track of the status of members. In the table is
member_id int(8)
status_code char(1)
status_date date
KEY member_id (member_id,status_code,status_date)
Each member can have multiple records because a record is added each time
the status changes but the old record i
I am not much of a SQL guru so I am having trouble trying to figure out how
to format a SQL statement.
I have a table with members named members. Each member has only 1 record.
Then I have a table with member telephone numbers in it name
membertelephones. A member can have more than one telephone
