>Maybe this is a silly question but i really don´t understand why when i see the "tastrade" sample views there´s no relations in "join" and only uses "filters".
>When i try to do my local views i can´t do the same.
>
>TIA
>
Eduardo,
Is because those views date back to VFP 3.0 where the JOIN syntax on SELECT didn't exist. The JOINs are done using the WHERE (filter) clause of the SELECT command. The following two views are equivalent;
SELECT * ;
FROM Cust, Invoice ;
WHERE Cust.CustId = Invoice.CustID
SELECT * ;
FROM Cust JOIN Invoice ON Cust.CustID = Invoice.CustID