<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
曾经用access生成一个超复杂的 sql语句,用了很多leftjoin...on ,然后检索的每一个字段都必须加上 groupby,任何一个去掉都产生错误,我一直不明白为什么这样,然后昨天在csdn上面提问了,但是还是没能明白.今天再次用两表连接查询然后 groupby,好像页必须所有检索字段都加入才成.
eg:
selectsupplier.idassupplierid,supplier.shortnameassupplierfromsupplier,dingdan_productwheresupplier.id=[dingdan_product].supplieridand[dingdan_product].dingdanid=4 groupbydingdan_product.supplierid,supplier.id,supplier.shortname
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
曾经用access生成一个超复杂的 sql语句,用了很多leftjoin...on ,然后检索的每一个字段都必须加上 groupby,任何一个去掉都产生错误,我一直不明白为什么这样,然后昨天在csdn上面提问了,但是还是没能明白.今天再次用两表连接查询然后 groupby,好像页必须所有检索字段都加入才成.
eg:
selectsupplier.idassupplierid,supplier.shortnameassupplierfromsupplier,dingdan_productwheresupplier.id=[dingdan_product].supplieridand[dingdan_product].dingdanid=4 groupbydingdan_product.supplierid,supplier.id,supplier.shortname
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>