Re: Error filling record group with nested select

[Quoted] Am 19 Jan 2005 04:01:51 -0800 schrieb Javier Coego <javiercoego_at_gmail.com>:

> - Hi, all. -
>
> - I'm trying to fill a record group with the values returned by the
> following query: -
>
> select username from user_accounts where username not in (select
> username from assigned_accounts where end_date<start_date)

[Quoted] Try to use table aliases:

select ua.username
  from user_accounts ua
   where ua.username not in (select aa.username

                              from  assigned_accounts aa
                               where  aa.end_date < aa.start_date)

Verify the references of end_date and start_date.

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)