Re: [SQL] where not unique

2004-03-12 Thread Paul Thomas
On 12/03/2004 13:02 Gary Stainburn wrote: Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need to print out a list of stock number and reg number where reg number is not unique (cherished number plate transfer not completed). I've tried

Re: [SQL] where not unique

2004-03-12 Thread Daniel Henrique Alves Lima
You're right, Reinoud. Sorry for my mystake... Reinoud van Leeuwen wrote: On Fri, Mar 12, 2004 at 10:54:25AM -0300, Daniel Henrique Alves Lima wrote: Gary Stainburn wrote: Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need t

Re: [SQL] where not unique

2004-03-12 Thread Daniel Henrique Alves Lima
Gary Stainburn wrote: Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need to print out a list of stock number and reg number where reg number is not unique (cherished number plate transfer not completed). I've tried variations of a

[SQL] where not unique

2004-03-12 Thread Gary Stainburn
Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need to print out a list of stock number and reg number where reg number is not unique (cherished number plate transfer not completed). I've tried variations of a theme based on select