Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
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
Précédent
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