Re: [SQL] weird(to me) request

2003-09-25 Thread Larry Rosenman
--On Thursday, September 25, 2003 20:09:35 +0100 Richard Huxton <[EMAIL PROTECTED]> wrote: On Thursday 25 September 2003 19:51, Larry Rosenman wrote: I have the following rows (in addition to others): acct_num text, master_acct_num text, These are in the same table. What I want to enforce is

Re: [SQL] weird(to me) request

2003-09-25 Thread Richard Huxton
On Thursday 25 September 2003 19:51, Larry Rosenman wrote: > I have the following rows (in addition to others): > > acct_num text, > master_acct_num text, > > > These are in the same table. > > What I want to enforce is that if the master_acct_num field is NOT NULL (it > can be NULL, and > that's f

Re: [SQL] weird(to me) request

2003-09-25 Thread Larry Rosenman
--On Thursday, September 25, 2003 20:59:25 +0200 Adam Wieckowski <[EMAIL PROTECTED]> wrote: U¿ytkownik Larry Rosenman napisa³: I have the following rows (in addition to others): acct_num text, master_acct_num text, These are in the same table. What I want to enforce is that if the master_acc

Re: [SQL] weird(to me) request

2003-09-25 Thread Adam Wieckowski
Użytkownik Larry Rosenman napisał: I have the following rows (in addition to others): acct_num text, master_acct_num text, These are in the same table. What I want to enforce is that if the master_acct_num field is NOT NULL (it can be NULL, and that's fine), that the value appears in some row a

[SQL] weird(to me) request

2003-09-25 Thread Larry Rosenman
I have the following rows (in addition to others): acct_num text, master_acct_num text, These are in the same table. What I want to enforce is that if the master_acct_num field is NOT NULL (it can be NULL, and that's fine), that the value appears in some row as acct_num. acct_num has a unique