public static final String TABLE= "create table tb("+ "_id INTEGER PRIMARY KEY,"+ "name TEXT ,"+ "telPhone TEXT ,"+ "groupID TEXT,"+ "gpsState TEXT"+ ");";mSQLiteDataBase.execSQL(TABLE);
select Grage.g_grage,Student.s_name,Student.s_no,Course.c_name,Course.c_no from Grage,Student,Course where Grage.C_id=Course.Cid and Grage.S_id=Student.Sid and Gid=? 大家帮我看看这个sql语句有什么问题?或者帮我修改下!谢谢!马上就结贴!
"create table tb("+
"_id INTEGER PRIMARY KEY,"+
"name TEXT ,"+
"telPhone TEXT ,"+
"groupID TEXT,"+
"gpsState TEXT"+
");";mSQLiteDataBase.execSQL(TABLE);
from Grage,Student,Course
where Grage.C_id=Course.Cid
and Grage.S_id=Student.Sid and Gid=?
大家帮我看看这个sql语句有什么问题?或者帮我修改下!谢谢!马上就结贴!