sqlStr = "select DISTINCT SLOTTYPE.DISPLAYLABEL, SLOT.USERLABEL, SLOT.DN, SLOT.ID, SLOTTYPE.LOGICALSLOTNO from SLOT, SLOTTYPE, CIRCUITPACK where SLOT.SLOTTYPEID *= SLOTTYPE.ID and SLOT.SUBNEID = ";
sqlStr = "select DISTINCT SLOTTYPE.DISPLAYLABEL, SLOT.USERLABEL, SLOT.DN, SLOT.ID, SLOTTYPE.LOGICALSLOTNO from SLOT, SLOTTYPE, CIRCUITPACK where SLOTTYPE.ID = SLOT.SLOTTYPEID(+) and SLOT.SUBNEID = ";这样一句语句中 *=是啥意思 还有 就是(+)
sqlStr = "select DISTINCT SLOTTYPE.DISPLAYLABEL, SLOT.USERLABEL, SLOT.DN, SLOT.ID, SLOTTYPE.LOGICALSLOTNO from SLOT, SLOTTYPE, CIRCUITPACK where SLOTTYPE.ID = SLOT.SLOTTYPEID(+) and SLOT.SUBNEID = ";这样一句语句中 *=是啥意思 还有 就是(+)
解决方案 »
- 如何采用mysql实现oracle的decode()函数的来解决一个查询问题??急!急!
- SELECT id FROM reviews WHERE MATCH (data) AGAINST ('single') 没有结果返回
- 这读取有毛病吗
- mysql分区如何将数据文件分配比较好?
- ER图和EER图
- 数据库字段值同步
- 新建表时能不能这样指定字段的缺省值
- 请问是学MY SQL好还是学 SQL SERVER 好?
- 我这样用lock table有什么问题呢?正确的应该怎么用啊?
- centos下转移了mysql的数据文件后报错(求解答在线等)
- 何如用trigger rule 或者assertion 解决这几个constraint
- 请教MYSQL设置BUFFER的问题 另外求教读源码的建议
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html