我有一个内容表table_content id title time 和很多个内容模型table_content_1,table_content_2,table_content_3分表,里面有一个公用的字段content table_content里面id和table_content_1,table_content_2,table_content_3总有一个是能对应的 现在呢我想遍历当前栏目下面所有内容模型的内容,取table_content和内容使用的模型对应(table_content_1,
SQL code
select * form table_content A, (
select id, content from table_content_1
union all
select id, content from table_content_2
union all
select id, content from tabl……
[/Quote]
正是如此啊,太感谢唠叨高手了,我刚用的试图搞的,没想到sql还能这样写啊
select * form table_content A, (
select id, content from table_content_1
union all
select id, content from table_content_2
union all
select id, content from table_content_3
) T where A.id=T.id