Skip to content

Instantly share code, notes, and snippets.

@dmregister

dmregister/gist:fb753338797f18fbab58

Created May 13, 2015 18:29
Show Gist options
  • Save dmregister/fb753338797f18fbab58 to your computer and use it in GitHub Desktop.
Save dmregister/fb753338797f18fbab58 to your computer and use it in GitHub Desktop.
Download ZIP
select
Raw
gistfile1.txt
$sql = new Sql($this->adapter);
$select = $sql->select()->columns(array('c.city', 'c.state', 's.count'), false)
->from(array('s' => 'statistic'))
->join(array('c' => 'city'), 's.city_id = c.id');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment