Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi please tell me how to use join for more two tables data
$user_source = $this->src('user_source')->query("select id,name from users");
$purchase_source = $this->src('purchase_source')->query("select user_id,item,amount from purchases");
$join = new Join($user_source,$purchase_source,array("id"=>"user_id"));
$join->pipe($this->dataStore('together'));
Hi Ankit,
You apply the same concept to join the third table.
$user_source = $this->src('user_source')->query("select id,name from users");
$purchase_source = $this->src('purchase_source')->query("select user_id,item,amount from purchases");
$join = new Join($user_source,$purchase_source,array("id"=>"user_id"));
$together = new Join($join,$another_source,array("id"=>"user_id"));
$together->pipe($this->dataStore('together'));
Hope that helps.
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo