Pagination problems encountered in sql statement, please come to see, thank you!!

Category: Web Develop
 
hou_1026
2010-11-16 11:27:17

Sponsored Links
select count (*) from
(SELECT t_cus_product.id, t_customer.name, t_products.name, t_cus_product.pdtypeid, t_cus_product.startdate, t_cus_product.enddate, t_cus_product.pstatus
FROM t_cus_product Inner Join t_products ON t_products.id = t_cus_product.pdid Inner Join t_customer ON t_customer.id = t_cus_product.cusid) as page_t

blue portion out running without problems. entire run when it prompts :1060-Duplicate column name 'name'

Sponsored Links

shixw110
2010-11-16 11:37:44
t_customer.name, t_products.name, put this change it, followed by an alias, such as t_customer.name cname, t_products.name pname, because you do not keep up with the alias will appear in a subquery two identical column names being given
aihua2010
2010-11-16 11:49:23
you first check select *
the select count (*) remove
Domain and server ip had changed since 8/23/2013. Suspend the user registration and posts for program maintenance.