sql联合查询的详细讲解 select * from 表A,表A子表 where 表A.FileCode = 表A子表.FileCode and 表A.ID in (select 表A子表.ID from 表A子表 where Vc_Code = '1190' AND Vc_Num ='111300' AND Er_Num ='0101'); 这个查询的条件在子表，而结果在父表，没用关联查询，直接查询2个表
SQL 联合查询与XML解析实例
这里举例说明如何实现该功能：
(select a.EBILLNO,
a.EMPNAME,
a.APPLYDATE,
b.HS_NAME,
replace(replace(a.SUMMARY,char(10), ''),char(13),'') as SUMMARY,
cast(c.XmlData as XML).value('(/List/item/No/text())[1]','NVARCHAR(300)') as No,
cast(c.
