sqlÓï¾ä Çó´í£¡

select * from zzq_shangjia_liuyan where UserName in (select card_id from [card] where card_sales='"&session("gwid")&"'£©

±¨´í£ºËµ¡°£©¡±¸½½üÓÐÓï·¨´íÎó£¡
²»ÖªµÀ´íÔÚÄÄÀïÁË!


Èç¹û°Ñ'"&session("gwid")&"'  Ö±½Ó»»³É¾ßÌåµÄid¾ÍÄÜÕý³£²éѯÊý¾Ý£¡

ÏòÏÂÃæÕâÑù£º
select * from zzq_shangjia_liuyan where UserName in (select card_id from [card] where card_sales=431£©

¾ÍÕý³££¡

---

select * from zzq_shangjia_liuyan where UserName in (select card_id from [card] where card_sales='"&session("gwid")&"'£©

ʲôÓ﷨ѽ,Õâ¸öÓ¦¸ÃÊÇÒªÔÚ³ÌÐòÖвÅsession»ñÈ¡ºó¸³ÖµµÄ°É

---

ÄãµÄ×îºóÒ»¸öÀ¨ºÅºÃÏñÊÇÈ«½ÇµÄ

---

ÒýÓÃ

ÄãµÄ×îºóÒ»¸öÀ¨ºÅºÃÏñÊÇÈ«½ÇµÄ

àÅ,¶ÔºÇºÇ,·ûºÅÑÕÉ«²»¶Ô

---

SQL code:
"
select
*
from
zzq_shangjia_liuyan
where
UserName
in (select card_id from [card] where card_sales='" & session("gwid") & "'£©"

---

×îºóÄǸöÀ¨ºÅÄãÊÇÈ«½ÇµÄ°É


select * from zzq_shangjia_liuyan where UserName in (select card_id from [card] where card_sales='"&session("gwid")&"')

---

ÎÒÊÇÂ¥Ö÷£¡

card_sale ÊÇÊýÖµÐÍ£¡