2009年2月27日星期五

Re: [fw-db] Column ambiguously defined

Oh yeah, I see it, didn't look good enough... anyway. You should rename one
of the id's.

e.g. the one from INDIVIDUS: IND_ID AS BLABLA. But better I think, you
should only let the select, select one of the two id's.

e.g.
$select->joinInner(array("AFF" => "EAI_TA_AFFECTATIONS"),
'INDIVIDUS.IND_ID = AFF.IND_ID',array('field1','field2','field3));
so the 3the parameter is the fields you want to select from this table.
Select them all but not IND_ID.

http://www.phpscriptor.com/tutorial/zend/zend.db.select.html#zend.db.select.building.join
http://www.phpscriptor.com/tutorial/zend/zend.db.select.html#zend.db.select.building.join


Thomas VEQUAUD wrote:
>
> Yep I have an IND_ID in each tables... That's why I don't understand this
> issue...
> If you've got another idea... Just show me the right way! ;)
>


-----
visit my website at http://www.phpscriptor.com/ http://www.phpscriptor.com/
--
View this message in context: http://www.nabble.com/Column-ambiguously-defined-tp22248675p22255854.html
Sent from the Zend DB mailing list archive at Nabble.com.

没有评论: