Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement