linzhoulxyz
发贴: 9
积分: 0
|
于 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.
哪位大侠能帮我解决这个问题啊???
|