Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select SQL
Message
From
01/07/2003 11:53:45
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00805730
Message ID:
00805732
Views:
16
This message has been marked as the solution to the initial question of the thread.
Olá Vinicius!

Para isto você tem que usar a claúsula "Left Join", que pode ser assim:
SELECT Tab1.Codigo, Tab2.Codigo from tab1 Left Join tab2 On tab1.codigo = tab2.codigo

* Ou

SELECT Tab1.Codigo, Tab2.Codigo from tab1, tab2 where tab1.codigo *= tab2.codigo  && Com o "*", funciona no SQL Server não me recordo se no VFP tb
Até mais.
Erick
Força Sempre!
Strength Always!
Previous
Reply
Map
View

Click here to load this message in the networking platform