General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only