select loan.*,borrower.* from loan inner join borrower on loan.loan_number=borrower.loan_number as lb(loan_number,branch,amount,cust,cust_loan_num) 这个代码最后的一句使用as子句重新命名连接的结果关系,可是编译的时候却出现了错误,这是怎么回事啊 大家帮我看看吧
select branch_name, avg_balance
from (select branch_name, avg(balance)
from accout
group by branch_name)
as branch_avg(branch_name, avg_balance)……
[/Quote]
with lb(loan_number,branch,amount,cust,cust_loan_num)
as
(select loan.*,borrower.*
from loan inner join borrower on loan.loan_number=borrower.loan_number)
select * from lb
[/Quote]
up.............
with lb(loan_number,branch,amount,cust,cust_loan_num) as
(
select loan.*,borrower.*
from loan inner join borrower on loan.loan_number=borrower.loan_number
)
SELECT * FROM lb
with lb(loan_number,branch,amount,cust,cust_loan_num)
as
(select loan.*,borrower.*
from loan inner join borrower on loan.loan_number=borrower.loan_number)
select * from lb
建视图时有类似的写法
试试
create view lb(loan_number,branch,amount,cust,cust_loan_num)
as
select loan.*,borrower.*
from loan inner join borrower on loan.loan_number=borrower.loan_number
[Quote=引用 2 楼 rucypli 的回复:]
select loan.col1 as xxx,loan.col2 as xxxx,borrower.*
from loan inner join borrower on loan.loan_number=borrower.loan_number
[/Quote]