Ò»¸öSQLÓï¾äµÄÎÊÌâ - PHP / »ù´¡±à³Ì

SELECT `a`.`MaterialNum`,`a`.`PicName`,`a`.`PartName`,`a`.`StepID`,`b`.`StepName`,`b`.`StepTime`,`b`.`UnitPrice`,`b`.`Quota` from ty_process as `a`,ty_partstep as `b`WHERE `a`.`PicName`=`b`.`PicName` and `a`.`PicName` like 'FDH-2101%' and `b`.`StepID` like concat(`a`.`StepID`,'%') 
Õâ¸ösqlÖÐ`b`.`StepID` like concat(`a`.`StepID`,'%') ÓÐÎÊÌ⣬`a`.`StepID`È¡²»µ½Öµ£¬Ó¦¸ÃÊÇ·ûºÅµÄÎÊÌ⣬ÊÔÁË°ëÌ춼²»ÐУ¬ÒýºÅ£¬Ë«ÒýºÅ¶¼ÊÔ¹ýÁË

---

·Åµ½ phpmyadmin ÀïÔËÐп´¿´

---

²»Ðа¡£¬ÎÒ°Ñconcat(`a`.`StepID`,'%')¸Ä³Éconcat(`1`,'%')¾ÍÐÐÁË£¬ÎÒÊÇÔÚPHPÒ³ÃæÖÐдµÄ

---

ÓÃAS ÊÔÊÔ.

---

²»Ðа¡£¬

---

¸çÃÇ,ÊÔÏÂÕâ¸ö.
SELECT a.MaterialNum,a.PicName,a.PartName,a.StepID,b.StepName,b.StepTime,b.UnitPrice,b.Quota from ty_process as a,ty_partstep as bWHERE a.PicName=b.PicName and a.PicName like 'FDH-2101%' and b.StepID like concat(a.StepID,'%')

---

²»Òª·ûºÅ

---

ÒýÓÃ

¸çÃÇ,ÊÔÏÂÕâ¸ö.
SELECT a.MaterialNum,a.PicName,a.PartName,a.StepID,b.StepName,b.StepTime,b.UnitPrice,b.Quota from ty_process as a,ty_partstep as bWHERE a.PicName=b.PicName and a.PicName like 'FDH-2101%' and¡­¡­

²»ÐÐ

---

ÒýÓÃ

²»Òª·ûºÅ

ʲôÒâ˼£¿

---

SELECT `a`.`MaterialNum`,`a`.`PicName`,`a`.`PartName`,`a`.`StepID`,`b`.`StepName`,`b`.`StepTime`,`b`.`UnitPrice`,`b`.`Quota` from ty_process as `a`,ty_partstep as `b`WHERE `a`.`PicName`=`b`.`PicName` and `a`.`PicName` like 'FDH-2101%' and `b`.`St