ASp.NET 连ACCESS数据库 System.Data.OleDb.OleDbException: FROM 子句语法错误。

string sqlstr = " select * from 电影类型 select b.MovieTypeID,b.电影名称,a.MovieTypeName,"
+ "b.电影评分,b.观看电影时间,b.观看的方式 from 电影类型 as a inner join 电影汇总 as b on a.MovieTypeID=b.MovieTypeID";

OleDbConnection Con = new OleDbConnection(ConStr);
OleDbDataAdapter Dap = new OleDbDataAdapter(sqlstr, Con);
DataSet myds = new DataSet();
Dap.Fill(myds);
程序运行出错:
System.Data.OleDb.OleDbException: FROM 子句语法错误。

string sqlstr = " select b.MovieTypeID,b.电影名称,a.MovieTypeName,"
+ "b.电影评分,b.观看电影时间,b.观看的方式 from 电影类型 as a inner join 电影汇总 as b on a.MovieTypeID=b.MovieTypeID";

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息