Chris,
Both the Query Designer and the View Designer are unable to handle more than two tables reliably. You need to design your SQL in a PRG. Once it's tested, you can use the Create Query or Create View commands to add a query/view to the DBC.
Don't forget to use Erik Moore's eView application to set properties on a view. It's in the Files/VFP in General section here on UT.
Barbara
>Edward
>
>I've been trying to do it using the Query wizard & getting all confused - looks like your simple approach works.
>
>Cheers
>
>
>Chris
>
>
>
>>>Hi all
>>>
>>>I've been trying to join three tables for the past four hours, and it's time to pull the ol hair out! I must be missing something (apart from the hair that is)...
>>>
>>>I've got three tables with a common field (account_no), and I have been trying to run a query which pulls the name field from table "A" (a single row) contract info (a single row) from table "B" and transaction data from table "C" (multiple rows) and join them together so that I get a report which provides the name & address & contract info on the first line with all the transactional data underneath.
>>>
>>>Any assistance would be muchly appreciated.
>>>
>>>Regards
>>>
>>>Chris Kable
>>>FuelTrac
>>
>>The simple case is:
>>
>>Select tableA.fieldZ..., tableB.fieldX..., tableC.fieldY ;
>>From tableA,tableB,tableC ;
>>Where tableA.acctnum=tableB.acctnum ;
>>And tableA.acctnum=tableC.acctnum
>>
>>There are some other cases, but let start with this one.