it will join what ever you have selected in the Network preference pane, under Airport tab. The best way to ensure you don't get back on a network is to "join a specific network" then select the one you'd rather go on; or, if you're not using airport at all any more, just disable the airport interface in "Network Port Configurations" option of the "Show" drop down menu.
HTH,
-- james