mssql关联查询关联字段值减半

浏览:456 发布日期:2014/08/25 分类:求助交流 关键字: mssql关联查询关联字段值减半
["modelSql":protected]=>
array(3) {
["attribute"]=>
string(207) "SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [onegar_attribute] WHERE ( attr_id =10 )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1)"
["_think_"]=>
string(91) "SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='onegar_attribute_value'"
["Attribute_value"]=>
string(184) "SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [onegar_attribute_value] WHERE ( 1=1 AND attr_id='5' )) AS thinkphp) AS T1 "
}

我想查表attribute的attr_id=10的数据和关联attribute_value表的数据

protected $_link = array(
'attr_value' => array(
'mapping_type' => self::HAS_MANY,
'class_name' => 'Attribute_value',
'foreign_key' => 'attr_id',
'mapping_name' => 'attr_value_list',
),
);
这是我的关联模型设置
最佳答案
评论() 相关
后面还有条评论,点击查看>>