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 ero...@comsquared.comwrote:
Can’t you use this?
select name from database2.sr_1 where name not in (select name from
database2.pr_1);
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
ero...@comsquared.com mailto:ero...@comsquared.com wrote:
Can’t you use this?
select