Most engines support NATURAL JOIN, which isn't perfect and has drawbacks, but allows for shorter joins.