select a.product_id,a.product_name,a.shop_id,a.shop_name,a.kind_code,a.product_price,a.product_pic as images,a.add_name
from v_p_product a left join dbo.f_get_provCity(a.product,a.shop_id) b on a.product_id=b.product_id
...全文
15223打赏收藏
这个SQL如何写啊?分不多了啊,给不了了。
select a.product_id,a.product_name,a.shop_id,a.shop_name,a.kind_code,a.product_price,a.product_pic as images,a.add_name from v_p_product a left join dbo.f_get_provCity(a.product,a.shop_id) b on a.product_id=b.product_id
select a.product_id,a.product_name,a.shop_id,a.shop_name,a.kind_code,a.product_price,a.product_pic as images,a.add_name
from v_p_product a left join dbo.f_get_provCity(a.product,a.shop_id) b on a.product_id=b.product_id