added ->join method

[trijin]

join method support alias for table and not simple ON statement

$db->books
   ->select('books.id, books.title, books2.id as id2, books2.title as title2')
   ->join('books as books2','books.author=books2.author AND books.id!=books2.id');