>Hello,
>
>
>I am trying to join two tables using the SHAPE command.
>
>"SHAPE {SELECT CustomerID,CompanyName" & _
> " FROM Customer ORDER BY CompanyName} " & _
>" APPEND ({SELECT OrderId, OrderDate, " & _
> " CustomerID FROM Orders} AS rsOrd " & _
>" RELATE CustomerID to CustomerID)"
>
>
>
>When I execute this statement... I get a syntax of access violation error..
>
>
>Any ideas?
>
>Thanks.
>
>Alvin

Alvin;

Try this:

"SHAPE {SELECT CustomerID,CompanyName" & _
     " FROM Customer ORDER BY CompanyName} " & _
     " APPEND (SELECT OrderId, OrderDate, " & _
     " CustomerID FROM Orders} AS rsOrd " & _
     " RELATE CustomerID to CustomerID)"

Tom