大家好，这几天试着钻研JOIN但还是无解....
快崩溃...OTZ

SELECT 'A' as t_name,id,category FROM A WHERE index= @str UNION SELECT 'B' as t_name,id,category FROMB WHERE index = @str UNION .....可以同时捞出表名做成列表 如果要排序最后+order就好