超级郁闷的sql,路过的进行来看看

[jxdyzwh]

SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM ((order_products INNER JOIN
products ON order_products.p_id = products.id) RIGHT JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code)
WHERE (len(PDClass.id_code) = 4)

这个语句有错吗,在access中怎么老说不支持链接表达式

[amingo]

帮LZ顶

[amanizty]

access 好象不支持DISTINCT
吧

[criedshy]

SELECT DISTINCT 
      PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code 
FROM order_products INNER JOIN 
      products ON order_products.p_id = products.id RIGHT JOIN 
      PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE (len(PDClass.id_code) = 4) 

你的扩号加的太多了

[Robin]

3 楼在Access中是行不通的
SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM ((order_products INNER JOIN
products ON order_products.p_id = products.id) RIGHT JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code)
WHERE (len(PDClass.id_code) = 4

是不是多了一个)
DISTINCT在Access中可以用吗

[jxdyzwh]

SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM ((order_products INNER JOIN
products ON order_products.p_id = products.id) right JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code)
WHERE len(PDClass.id_code) = 4
access是支持distinct的,现在碰上一个超级搞郁闷的问题
把right JOIN 换成left join就行了,怪事

[llsen]

[Quote=引用 3 楼 criedshy 的回复:]
SQL codeSELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM order_products INNER JOIN
products ON order_products.p_id = products.id RIGHT JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE (len(PDClass.id_code) = 4)

你的扩号加的太多了
[/Quote]

顶

[智者知已应修善业]

[Quote=引用 2 楼 amanizty 的回复:]
access 好象不支持DISTINCT
吧
[/Quote]

SQL语句都可以支持ACCESS的

[bhtfg538]

[Quote=引用 7 楼 xianfajushi 的回复:]
引用 2 楼 amanizty 的回复:
access 好象不支持DISTINCT
吧


SQL语句都可以支持ACCESS的
[/Quote]
错的 ,
比如MS SQL SERVER 就是使用的T-SQL

[白云任去留]

看下...