m***r
发帖数: 294 | 1 Table A (org_zip, dest_zip), Table zip(zipcode, city, state)
How to get
orig_city, orig_state, dest_city, dest_state
thanks, | c********g
发帖数: 449 | 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; | w******n
发帖数: 120 | 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,
|
|
