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,
相关阅读
Palantir靠的是军方关系Scala的map和flatmap什么区别？大家说有没有可能软件开发变成投行模式C++并发和Java并发有多大区别？建议马工们有机会多搞信息安全、安全开发方面的东西 (转载)Web Service的Basic Anthentication是怎么一回事？网站被黑，烙印外包成功把责任推到了中国头上 (转载)感觉flink出来之后，hadoop就显得不怎么再需要了ytube的一个bughn首页文章，is heron killing storm?C++11的lambda不会破坏可读性吗？能赚到钱才是王道，要那么多创造性干嘛？ (转载)How to Search Users within 50 miles away from me请问MySQL的replication不通过应用程序能达到strong consistenc (转载)寻IOS开发伙伴版上有CS 学位的 有多少能写个最简单的compiler?感觉Swift开源后有望到当年visual basic的高度大货车货运指挥app如何？Linux Makefile: How to include cpp files in subfolder for (转载)如何加强CORS的安全性？