--晕--这个测试能过吗?create table a(id int,efg varchar(10)) create table b(efg varchar(10),abc varchar(10),bcd varchar(10)) goselect a.*,b.abc,b.bcd from a,b where a.efg=b.efg and a.id=1 godrop table a,b
--改改测试的表名,免得与你库中现有的表冲突create table [a_826FE256-4856-4E18-99D3-1B1C7AE11AFE](id int,efg varchar(10)) create table [b_826FE256-4856-4E18-99D3-1B1C7AE11AFE](efg varchar(10),abc varchar(10),bcd varchar(10)) goselect a.*,b.abc,b.bcd from [a_826FE256-4856-4E18-99D3-1B1C7AE11AFE] a,[b_826FE256-4856-4E18-99D3-1B1C7AE11AFE] b where a.efg=b.efg and a.id=1 godrop table [a_826FE256-4856-4E18-99D3-1B1C7AE11AFE],[b_826FE256-4856-4E18-99D3-1B1C7AE11AFE]
很成功的建立表这是原句:select today_star.*,user.education,user.vocation from today_star,user where user.user_name = today_star.user_name and today_star.id=1因为怕...所以,看来还是全贴出来
select today_star.*,[user].education,[user].vocation from today_star,[user] where [user].[user_name] = today_star.[user_name] and today_star.id=1
第 1 行: '.' 附近有语法错误。我是sql数据库,通过access导入表的
SQL数据库已正常连接
--你用下面的语句,看看错误在那一行,再对应去修改select a.*,
b.abc,
b.bcd
from a,b
where a.efg
=b.efg
and a.id=1
第 2 行: '.' 附近有语法错误。B表的abc字段为nvarchar 里面数据为二个中文字
第 2 行: '.' 附近有语法错误。变成 b.bcd 有问题了??
create table b(efg varchar(10),abc varchar(10),bcd varchar(10))
goselect a.*,b.abc,b.bcd
from a,b
where a.efg=b.efg and a.id=1
godrop table a,b
create table [b_826FE256-4856-4E18-99D3-1B1C7AE11AFE](efg varchar(10),abc varchar(10),bcd varchar(10))
goselect a.*,b.abc,b.bcd
from [a_826FE256-4856-4E18-99D3-1B1C7AE11AFE] a,[b_826FE256-4856-4E18-99D3-1B1C7AE11AFE] b
where a.efg=b.efg and a.id=1
godrop table [a_826FE256-4856-4E18-99D3-1B1C7AE11AFE],[b_826FE256-4856-4E18-99D3-1B1C7AE11AFE]