# 试试看 Join

Posted by 小吴 on September 21, 1998 at 07:42:07:

In Reply to: 有关 SQL 的一个问题? posted by kkcheung on September 20, 1998 at 10:39:02:

如果你的目的只是为了取得 cust_name 的话，你可以试看看 join。
temp_st1="select A.cust_code, B.cust_name from sale_rec A, customer B where date='19980912' AND A.cust_code=B.cust_code"
tempset1=db.openrecordset (temp_st1)

while not tempset1.eof
temp_d1=tempset1!cust_code
temp_d2=tempset1!cust_name

tempset1.movenext
wend

Follow Ups:

- Re: 试试看 Join kkcheung 09:55:41 9/21/98 (1)
  - Re: 试试看 Join David Wong 14:03:24 9/24/98 (0)