>>>>In previous version of Visual FoxPro the view designer could not handle multiple joins to the same table is this still a problem in v7.0
>>>
>>>Yes it is! I think MS Team should really fix this or just buy e-view from E. Moore and integrate it in VFP and release it during SPs. Voodoo and WC are also great additional stuffs. :)
>>
>>Jess, I was able to do a self join without problems in 7.0. Can you send me your SQL so that I can duplicate it?
>
>The problem isn't with self-joins, but with what I call multiple unrelated children. That's where you have a single parent, but several child tables, with no relationship among the child tables. For example, using TasTrade, imagine a query of Orders where you want to get the Shipper, the Supplier and the Customer. The QD/VD can't handle that.
>
>Tamar
Thanks for clearing that up.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only