我刚写了一个,给你看看,
select funds.numberedAccount, funds.amountOfMoney,
funds.accountOpenTime,
cust.customerId,cust.name
from FundsAccount as funds
join funds.customers as cust
where funds.numberedAccount='2006'
可到我blog看看,写的细点,:http://blog.csdn.net/lzb821/archive/2006/11/30/1422363.aspx
select funds.numberedAccount, funds.amountOfMoney,
funds.accountOpenTime,
cust.customerId,cust.name
from FundsAccount as funds
join funds.customers as cust
where funds.numberedAccount='2006'
可到我blog看看,写的细点,:http://blog.csdn.net/lzb821/archive/2006/11/30/1422363.aspx
当然了,没区别
但是这样可以连接查询同时取出关联的对象,而这样记忆可以用一条SQL语句就查出自己及关联对象,提高性能!