这样的SQL语句在Access中怎么实现...高分求救..符合就给分....

[penglewen]

(select id=1,parentId=-1,text='共享区域',hint='所有共享',icon='', data='', url='#', target='_self', method='')
union
(
select id,parentId,text,hint,icon, data, url, target, method from tbA
)


select id=1 好象Access中这种语法有错误......高手请指点一下.......急.....

[penglewen]

select text=tbA.con1+'&&&&'+tbA.con2 from tbA 这种也有错误...如果要这种写法.请怎么改?????????????

[marco08]

查ACCESS的聯機幫助

[fellowcheng]

select id,parentId,text,hint,icon, data, url, target, method from tbA
union
(select 1,1,'共享区域','所有共享','','', '#','_self', '')

[fellowcheng]

select id,parentId,text,hint,icon, data, url, target, method from tbA
union
(select 1,1,'共享区域','所有共享','','', '#','_self', '' from tbA)