sqlÓï¾äÆæ¹ÖÎÊÌâ

ÎÒµÄsqlÓï¾äÈçÏ£º

select a.productname,a.sell_price,b.id from umc_product a left join umc_product_image b on a.id=b.id where a.id='1034';

°Ñ½á¹û·ÅÔÚ¸ö$arrÀÕâʱ$arr[0]ÓÐÖµ£¬$arr[1]ÓÐÖµ£¬µ«$arr[2]Àïûֵ,ÓÃ$arr['id']Ò²Äò»µ½¡£

µ«ÊÇsqlÓï¾ä¸Äµ½ÈçÏÂ,$arr[2]Àï¾ÍÓÐÖµÁË¡£

select a.productname,a.sell_pricea.id from umc_product a left join umc_product_image b on a.id=b.id where a.id='1034';

Ò²¾ÍÊÇÄò»µ½b±íÖеÄ×ֶΡ£

ÕâÊÇʲôԭÒò£¿

---

a.id=b.id  ûÓÐÆ¥ÅäµÄ¼Ç¼£¬²»ÓÃÆæ¹ÖµÄ

---

select a.productname,a.sell_pricea.id from umc_product a left join umc_product_image b on a.id=b.id where a.id='1034';
Õâ¾äÃ÷ÏÔÊÇ´íÎóµÄa.sell_pricea.id

---

²»¿ÉÄÜ£¬ÔÚÊý¾Ý¿âÖ´ÐÐÊÇÓмǼµÄ

¶øÇÒÈç¹ûû¼Ç¼£¬ÄÇa.idÒ²³ö²»À´

---

select a.productname,a.sell_price,a.id from umc_product a left join umc_product_image b on a.id=b.id where a.id='1034'

´ò×Ö´ò´íÁË

---

PHP code:

select b.productname,b.sell_price,a.id from umc_product_image a left join umc_product b on a.id=b.id where b.id='1034';

¸Ä³ÉÕâÑùÊÔÊÔ

---

ÓõÄÊÇleft join £¬umc_product_image ÓÐûÓмͼ¸úa.idÊÇûÓйØϵµÄ

---

select * from umc_product_image where id='1034';¿´ÓÐûÓмǼ£¿

---

select * from umc_product_image where id='