sql - query last Renewal of licences -


suppose have client renewal of licences every year. how query last year clients had renew licences per section... tried code , worked fine produce max year in section i.e 2014 though there clients have no renew licences since 2012...

select @last_expired_date = max(expired_license_date)     entrepreneur     right outer join firm_info         on entrepreneur.entre_id = firm_info.entre_id     right join section         on firm_info.section_id = section.section_id     right join license         on firm_info.firm_no = license.firm_no     right join license_operations         on license.license_serial = license_operations.license_serial     section.section_id = @section_no     group license.license_serial

you need add client name select , group by clause, give list of clients , latest year have renewed license.

as note: use alias table names in joins. helps identify columns come tables. additionally avoid using right join because can make harder understand data getting.


Comments

Post a Comment

Popular posts from this blog

jquery - isAjaxRequest always return false -

i got error message 404,'model has not been saved' following code my action controller public function actionextend($id) { $model=$this->loadmodel($id); if(yii::app()->request->isajaxrequest) { $model->todate = date('y-m-d h:i:s a',(strtotime('next month',strtotime(date('y-01-d'))))); if($model->save()) { yii::app()->end(); } else { throw new chttpexception(404,'model has not been saved'); } } } the jquery call $("#buttonextend<?php echo $this->post_row;?>").click(function(e){ $.ajax({ type: "post", url: "<?php echo yii::app()->createurl('post/extend', array('id' => $data['id'])); ?>", }); }); why not ajax call ? thank help i found response, missed } , function ...
Read more

php - SPIP: From Tag directly to an article -

i work spip , plugin called tagsphere works fine tags in spip. have tag groupe put 1 article tag. when click on tag in tagsphere send me before menu can see articles linked tag. want send me directly article without see tag menu before. here code model of thagsphere: <div id="tagsphere-#env{id_article}"> <ul> <boucle_mot(mots){id_groupe ?}> <li>[<a href="#url_mot">(#titre)</a>]</li> </boucle_mot> </ul> </div> anybody idea? if want skip tag page, have link directly article. <b_article> block prevents display tag if no article linked. <div id="tagsphere-#env{id_article}"> <ul> <boucle_mot(mots){id_groupe ?}> <b_article> <li> <a<boucle_article(articles){...
Read more