Hi ,
The query is like this ,
Except
SELECT * from ((SELECT COUNT(id) FROM table1) Except (SELECT COUNT(id)
FROM table2))tmp
Regards,
Ram
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Craig Ringer
Sent: Thursday, May 22, 2008 9:05 PM
To: Nacef LA
HI Sumaya,
This is the way you have to use dblink. And one more think.
To excute this query you nedd to have dblink functions installed in your
database schema.
select * from dblink('YOUR_DB_LINK_NAME','select * from mytable')as
tmp(column1 datatype,column2 datatype.)
Regards,
R
