Yes, you could put the intake tube in one of the tanks and then put the outtake into the other. Then connect the tanks with a water bridge. There's a great thread about doing this here.
I've always wanted to do something like this but I only have one tank and can't find clear piping.
I cant help you with anther tank but if your in the uk i can help you with the clear plasstic tubing, click HERE for an ebay link to a company that will sell you any size clear plastic tubing t a good price.