Is there public transportation between San Francisco Airport and Oakland Airport?

Not directly. You'll need to take a bus or BART into SF and then pick up a bus from the central station. Or fly to a different airport, like Fresno or San Jose and get a bus from there. Modesto also has an airport; you might check into whether you can fly directly.