SQL question# Programming - 葵花宝典
m*r
1 楼
Table A (org_zip, dest_zip), Table zip(zipcode, city, state)
How to get
orig_city, orig_state, dest_city, dest_state
thanks,
How to get
orig_city, orig_state, dest_city, dest_state
thanks,
c*g
2 楼
just try to give you some ideas.
Maybe wrong.
first get the org_city and org_state then use another select to get des_city
and state
Table A (org_zip, dest_zip), Table zip(zipcode, city, state)
select zip.city as org_city ,zip.state as org_state, A.dest_zip into table C
from A,zip
where A.org_zip=zip.zipcode;
select C.city,C.state,zip.city as des_city, zip.state as des_state
from C ,zip
where c.dest_zip=zip.zipcode;
Maybe wrong.
first get the org_city and org_state then use another select to get des_city
and state
Table A (org_zip, dest_zip), Table zip(zipcode, city, state)
select zip.city as org_city ,zip.state as org_state, A.dest_zip into table C
from A,zip
where A.org_zip=zip.zipcode;
select C.city,C.state,zip.city as des_city, zip.state as des_state
from C ,zip
where c.dest_zip=zip.zipcode;
w*n
3 楼
select org_zip,orig_state=state.zip1, dest_city=city.zip2,dest_state=state.
zip2
from A , zip as zip1, zip as zip2
where A.org_zip=zip1.zipcode and A.dest_zip=zip2.zipcode
【在 m***r 的大作中提到】
: Table A (org_zip, dest_zip), Table zip(zipcode, city, state)
: How to get
: orig_city, orig_state, dest_city, dest_state
: thanks,
zip2
from A , zip as zip1, zip as zip2
where A.org_zip=zip1.zipcode and A.dest_zip=zip2.zipcode
【在 m***r 的大作中提到】
: Table A (org_zip, dest_zip), Table zip(zipcode, city, state)
: How to get
: orig_city, orig_state, dest_city, dest_state
: thanks,
相关阅读
算了, 我还是把这个版Z掉吧how to destruct list with loop?学visual c++对找工作有用吗？弱问:C的for/while循环能在括号里面continue吗？looking for summer interns (转载)clarifyC++ Primer 上关于inheritance protected member 的一段话一个django问题：debug=true就很好；debug=false，css就找不到Is it safe to use unique_ptr with STL container?HTML5 for .NET Developers大家来看看这个纯Javascript实现的QR二维码生成器python哪个JSON库最好？nsa的big data项目, 学data mining的人有工作了 (转载)今天电面又被老印黑了。。。。 (转载)How solid it is: c++/c# call Matlab libraryPython: how to match the price string starting with $ ?一个关于Delphi的八卦买不起 visual studio 和 matlabcross origin resource sharing求问：游戏中比较自然的路径寻找算法有啥简单方案？