[求助]select 别名问题 Post By:2017/9/28 11:05:00 [显示全部帖子]
老师,
select 别名问题,下列代码错误,应该如何写呢?
select Distinct{表A}.[试试1],{表B}.[ID],{表B}.[试试2],{表C}.[ID],{表C}.[权限],{表A}.[ID] as xxd fr om (({表A} Inner JOIN {表B} on {表A}.[ID]={表B}.[ID])Inner JOIN {表C} on {表A}.[ID]={表C}.[ID]) where xxd='1'