关于ＭＳＳＱＬ的问题

carlos_cao

是这样的,现在我有3个表,3个表的结构都是一样的.我要把3个表里的数据都提出来,现在我已经提出来了,但我现在还想在提出来的数据后加一个字段"USE_TABLE",就是该行记录是属于哪个表的.这个SQL语句应该怎么写啊??



select s.*,t.id,t.typename from (select * from t_business_product_1 union all select * from t_business_product_2 union all select * from t_business_product_3 ) s,t_business_type t where me_ver='cn' and s.type_id=t.id

blue_stone

oracle 中可以用下面语句完成
select s.*,t.id,t.typename from (
select ‘t_business_product_1` tablename, t_business_product_1.* from t_business_product_1
union all
select  ‘t_business_product_2` tablename, t_business_product_2.* from t_business_product_2
union all
select  ‘t_business_product_3` tablename, t_business_product_3.* from t_business_product_3 ) s,
t_business_type t where me_ver='cn' and s.type_id=t.id
sqlserver中也应该有类似的语句

carlos_cao

就是这句了,谢谢了

carlos_cao

还是有点问题
就是在查询分析器里运行出来了,但写进ASP的时候就说找不到tablename这个字段了

carlos_cao

upupup