huoche表int id;
String checi;
int zhanci;
String chezhan;
String daoda;
String kaiche;
String leixing;
int licheng;
int tianshu;
int yunxing;
int ileixing;
String yingzuo;
String ruanzuo;
String yingwo;
String ruanwo;
String yidengruanzuo;
String erdengruanzuo; checi表 int id;
String checi;
String shifa;
String zhongdian;
String kaiche;
String daoda;
int yunxing;
int licheng;
int tianshu;
String leixing;
int ileixing;
int yingzuo;
String ruanzuo;
int yingwo;
int yingwozhong;
int yingwoshang;
int ruanwo;
int ruanwoxia;
String lastuptime;
int yidengruanzuo;
int erdengruanzuo;
这是两张表!我想做一个查询查找车站!例如查北京 从北京发车或者是经过北京的所有车次,始发站等等详细信息查询出来!不知道Sql语句怎么写!我用的是Access数据库!连接方式我写出来了!哪位高手能帮忙把方法写出来呀!我用的是JavaBean和Servlet做的!谢谢!哥们分不多!帮帮吧!
String checi;
int zhanci;
String chezhan;
String daoda;
String kaiche;
String leixing;
int licheng;
int tianshu;
int yunxing;
int ileixing;
String yingzuo;
String ruanzuo;
String yingwo;
String ruanwo;
String yidengruanzuo;
String erdengruanzuo; checi表 int id;
String checi;
String shifa;
String zhongdian;
String kaiche;
String daoda;
int yunxing;
int licheng;
int tianshu;
String leixing;
int ileixing;
int yingzuo;
String ruanzuo;
int yingwo;
int yingwozhong;
int yingwoshang;
int ruanwo;
int ruanwoxia;
String lastuptime;
int yidengruanzuo;
int erdengruanzuo;
这是两张表!我想做一个查询查找车站!例如查北京 从北京发车或者是经过北京的所有车次,始发站等等详细信息查询出来!不知道Sql语句怎么写!我用的是Access数据库!连接方式我写出来了!哪位高手能帮忙把方法写出来呀!我用的是JavaBean和Servlet做的!谢谢!哥们分不多!帮帮吧!
from huoche A inner join checi B on A.checi = B.checi
where A.chezhan = 'beijing'
select c.* from checi c where c.checi in (select h.checi from huoche h where h.chezhan = 'beijing')
or
select c.* from checi c where exist (select 1 from huoche h where h.chezhan = 'beijing' and c.checi = h.checi)