马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册
×
我在修改一段代码的时候发现where条件里有*= 和=,不知道两者之间有什么区别?
select tr_memup.USERS_CORP_CD, USERS_SHOP_CD, tr_memup.USERS_MACHINE_CD, CORP_NM, tr_memup.CORP_J, CORP_TEL, CORP_ZIP, from tr_memup, mt_deal, mt_reason, mt_industry, mt_account, mt_machine, mt_corp where NEW_SEQ_NO = '12345' and tr_memup.USERS_CORP_CD *= mt_corp.CORP_CD and tr_memup.REASON_CD *= mt_reason.REASON_CD and tr_memup.ACCOUNT_TYPE_CD *= mt_account.ACCOUNT_CD and tr_memup.DEAL_CD *= mt_deal.DEAL_CD and tr_memup.INDUSTRY_CD *= mt_industry.INDUSTRY_CD and tr_memup.USERS_CORP_CD *= mt_machine.USERS_CORP_CD and tr_memup.USERS_MACHINE_CD *= mt_machine.USERS_MACHINE_CD |