Search results for query: *

I hope someone could provide some assistance. I am wondering if it is possible to connect a Watchguard Firebox III/1000 to a Cisco PIX firewall. The purpose of this is to allow a secure connection between our network and a hosted server. Please advise if this is possible and if at all...

I have now been informed that this is no longer required. So I thank you for your help. It has been really informative, even though I haven't been able to get any of the scripts that I've tried to work. I put that down to my own stupidity :-)

Would I need to create a join for each field in the table or just the one that I want to do the comparison on? I apologise for asking so many questions, but when it comes to coding like this I am a complete newbie

What does the a. and the b. represent?

Ok so should my select statement look something like this [Code/] SELECT customerid,customername FROM database1.owner.table1 WHERE not exists (select customerid, customername from database2.owner.table1 on database1.owner.table1.customerid = database2.owner.table1.customerid [/code]

Thanks for your prompt reply. I apologise I didn't mention this in my initial post. But the recovered table is in another database. What would I need to change in the insert statement if the table was in another database?

Hi I am currently trying to insert some data from another table, but would like to exclude any rows that contain duplicate data. Ok the story behind this to help you guys and girls to understand why I want to do this. Recently we ran a process on our accounts package and it removed some data...