大家帮忙看看这代码那里错了:
select tf.friend_name AS 客户名称,task_target_name AS 任务对象名称,task_intro1k AS 备注,task_due_date AS 完成期限,task_date AS 任务日期 ,
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from (((((tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id)
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id)
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key)
inner join tc_friend tf on tt.friend_id = tf.friend_id)
inner join tc_product tp on rtp.prod_id = tp.prod_id)
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'
--------------------------------------------
报错如下:
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_task' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'rel_task_prod' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_employee' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_user_enum_str' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_friend' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_product' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_department' 无效。
select tf.friend_name AS 客户名称,task_target_name AS 任务对象名称,task_intro1k AS 备注,task_due_date AS 完成期限,task_date AS 任务日期 ,
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from (((((tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id)
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id)
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key)
inner join tc_friend tf on tt.friend_id = tf.friend_id)
inner join tc_product tp on rtp.prod_id = tp.prod_id)
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'
--------------------------------------------
报错如下:
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_task' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'rel_task_prod' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_employee' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_user_enum_str' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_friend' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_product' 无效。
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'tc_department' 无效。
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from tc_task tt
inner join rel_task_prod rtp on tt.task_id = rtp.prod_id
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key
inner join tc_friend tf on tt.friend_id = tf.friend_id
inner join tc_product tp on rtp.prod_id = tp.prod_id
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'打括号那么多?
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key
inner join tc_friend tf on tt.friend_id = tf.friend_id
inner join tc_product tp on rtp.prod_id = tp.prod_id
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'
tf.friend_name AS 客户名称,task_target_name AS 任务对象名称,
task_intro1k AS 备注,task_due_date AS 完成期限,task_date AS 任务日期 ,
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,
td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from
(((((tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id)
inner join
tc_employee te on tt.task_assign_emp_id = te.emp_id)
inner join
tc_user_enum_str tue on tt.task_status =tue.user_enum_key)
inner join
tc_friend tf on tt.friend_id = tf.friend_id)
inner join
tc_product tp on rtp.prod_id = tp.prod_id)
inner join
tc_department td on tt.dept_id = td.dept_id
where
user_enum_location = 'task_status'
select tf.friend_name AS 客户名称,task_target_name AS 任务对象名称,task_intro1k AS 备注,task_due_date AS 完成期限,task_date AS 任务日期 ,
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from
tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key
inner join tc_friend tf on tt.friend_id = tf.friend_id
inner join tc_product tp on rtp.prod_id = tp.prod_id
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key
inner join tc_friend tf on tt.friend_id = tf.friend_id
inner join tc_product tp on rtp.prod_id = tp.prod_id
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'
是不是连错库了,所有表都报无效对象
task_sales_projection AS 销售预期,task_budget AS 预算,tue.user_enum_value AS 阶段 ,td.dept_name AS 部门,te.emp_name AS 员工,
tp.prod_code AS 产品编码 ,rtp.prod_volume AS 产品数量,RTP.PROD_last_price AS 价格from
tc_task tt inner join rel_task_prod rtp on tt.task_id = rtp.prod_id
inner join tc_employee te on tt.task_assign_emp_id = te.emp_id
inner join tc_user_enum_str tue on tt.task_status =tue.user_enum_key
inner join tc_friend tf on tt.friend_id = tf.friend_id
inner join tc_product tp on rtp.prod_id = tp.prod_id
inner join tc_department td on tt.dept_id = td.dept_idwhere user_enum_location = 'task_status'