Hi Nicholas,
The query is across database query. dblink is needed for that task.
Hope it helps,
John
On Thu, Apr 30, 2009 at 3:07 PM, Edward W. Rouse wrote:
> Can’t you use this?
>
>
>
> select name from database2.sr_1 where name not in (select name from
> database2.pr_1);
>
>
>
> My test da
On 05/01/2009 11:55 AM, John Zhang wrote:
Hi Nicholas,
The query is across database query. dblink is needed for that task.
Hope it helps,
John
On Thu, Apr 30, 2009 at 3:07 PM, Edward W. Rouse
mailto:ero...@comsquared.com>> wrote:
Can’t you use this?
select name from database2.s
