小李=小子李 小张=大张 张三=张四 相似何其难 不懂。。。 . 那要是就找相等的呢？ 比如小张=小张 SQL code: select gid,A.name1,money from A,B where A.name1=B.name
SQL code: SELECT a.*, b.gid from a INNER JOIN b ON charindex(b.name,a.name1)>0 OR charindex(a.name1,a.name)>0
SQL code: --------------------SQL Server数据格式化工具------------------- --------------------------------------------------------------- -- DESIGNER :happycell188(喜喜) -- QQ :584738179 -- Development Tool :Microsoft Visual C++ 6.0 C Language -- FUNCTION :CONVERT DATA TO T-SQL ------------------------------------------------------------
