求助:谁帮我看一下这个SQL语句怎么写?

select * from cststd
where rtrim(ltrim(group1))+rtrim(ltrim(proup2))+rtrim(ltrim(group3))+rtrim(ltrim(group4))
in
(select rtrim(ltrim(group1))+rtrim(ltrim(proup2))+rtrim(ltrim(group3))+rtrim(ltrim(group4)) from cstmom cm
join invmas i on cm.itnbr=i.itnbr) a

解决方案 »

  1.   

    select rtrim(ltrim(cststd.group1))+rtrim(ltrim(cststd.proup2))+rtrim(ltrim(cststd.group3))+rtrim(ltrim(cststd.group4)) from cststd
    where rtrim(ltrim(cststd.group1))+rtrim(ltrim(cststd.proup2))+rtrim(ltrim(cststd.group3))+rtrim(ltrim(cststd.group4)) 
    not in
    (select rtrim(ltrim(invmas.group1))+rtrim(ltrim(invmas.proup2))+rtrim(ltrim(invmas.group3))+rtrim(ltrim(invmas.group4)) from invmas inner join cstmom on invmas.itnbr = cstmom.itnbr)