Select a.*,b.name,b.pno from MainDbf a, member b where a.Mno=b.Mno into cursor temp


>I am still learning SQL SELECT syntax. I wish to JOIN 2 tables whereby ALL fileds from the main Table (MainDbf) are to be picked and only 2 Fields (Name,Pno) from the other table (Member) which has 10 fields. The JOIN Condition works but it picks ALL fields even from Table 2. I had tried it using "SELECT *,Member.Name AS Name,Member.Pno AS Pno FROM MainDbf JOIN Member ON MainDbf->Mno==Member.Mno WHERE ..... INTO Cursor Temp". How can I ensure that the only specific fields are picked from the Joined table (Member) ?.
>
>Please help
>
>
>Fred Matano