Java开发网 - [求助]请教大家一个SQL的查询问题

Topic: [求助]请教大家一个SQL的查询问题

1.[求助]请教大家一个SQL的查询问题

Posted by: linzhoulxyz
Posted on: 2006-03-11 16:50

题目是:
Consider the following account and customer tables:

cust_tbl

cust_id  title  e_first_name  e_last_name  address1  .
0  MR  Martin  Ma  .
1  MR  Kirs  Cheung  .
2  MR  Ricky  Chan  .
3  MR  Tom  Kwan  .
4  MR  Corporate Default  Corporate Default  .
5  MRS  Mary   Mok  .



acc_grp_cust_tbl

acc_group  Cust_id1  Cust_id2  Cust_id3  Cust_id4
1400  0  1  2
1500  3  4
1600  5

The acc_grp_cust_tbl table is responsible to store the customer ID, and the cust_tbl table is responsible to store customer personal information such as name, address, etc… Please write a SQL query in order to provide following result.

哪位大侠能帮我解决这个问题啊???

2.Re:[求助]请教大家一个SQL的查询问题 [Re: linzhoulxyz]	Copy to clipboard
Posted by: why Posted on: 2006-03-11 18:26 sigh..... Please write a SQL query in order to provide following result 閣下連把習作的問題好好抄上來的工夫也不用心做我們愛莫能助了

3.Re:[求助]请教大家一个SQL的查询问题 [Re: linzhoulxyz]	Copy to clipboard
Posted by: jackyangf Posted on: 2006-03-17 09:43 Please write a SQL query in order to provide following result 要求？