Thanks, Cruiser. The way the melody was played on the David Wilkie cut, I can't relate it to a drinking song.
The sound clip you found is nothing like the usual tune for "A Border Affair." Most confusing.