用于JOIN的drupal view2 views_query_alter

i'm trying to alter drupal view-2 query, basically want to add one more table. I'm able to alter the where clause of query using hook_views_query_alter() but don't know how to join one more table.i'm trying to alter drupal view-2 query, basica