Re: select statement for in inclusion list

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello again:

Two follow-up questions:

1) The weakness of this statement is that it only tests for
accountholders already present in accountmovements. Therefore I would
like to join with another table called "accountholders" so as to
include the users who have no history, i.e. have had no
accountmovements, and therefore qualified as well.

The structure of the table accountholders is
IDuser (int) - Primary Key
Lastname (varchar)
Firstname (varchar)

2) Alongside each qualified accountholder I need to show the date
(Datemovement) of the last time they received dividend. My problem is
that I would to return some kind of text (i.e "no history") whenever an
accountholder is not present in accountmovements, i.e. has had no
movements at all, OR simply has not had any movements with the text
"dividend" in the Text column.

Thanks

TB

.