The query Wizard shares the same bug as the view designer- it chokes on most queries with 2 or more joins.
>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.
Erik Moore
Clientelligence