What is the query trying to achieve? On 2/15/13 8:07 AM, "Prashanth Reddy Mandadi" <prashanthreddy.mand...@citrix.com> wrote:
>Hi, > >Should the following query return any results and if it does would it be >a bug? >(assuming it's for a shared network and no manual DB modifications are >performed) > >select id,public_ip_address from user_ip_address where state='Allocated' >and public_ip_address in (SELECT n1.ip4_address FROM nics n1 LEFT JOIN >nics n2 ON (n1.ip4_address = n2.ip4_address AND n1.id < n2.id) WHERE >n2.id IS NULL and n1.removed is not null); > >Regards, >Prashanth
