Hi steve,

I'm not that fond of using the SQL designer. All too often i'm stuck in some error, or come to the conclusion it is not as flexible as SQL in VFP.

One question though. Is it possible to execute the query in VFP (I don't know where the tables come from) or in any other environment and send the result as one table into for example a FOX 2.x table ?


Walter,

>I'm trying to help a friend that is struggling with Crystal and SQL - and I'm not a Crystal user.
>
>Data structure:
>Table1 "Household data"
>Table1.id (household data)
>Table1.address
>Table1.city ...
>
>Table2 "Payment history"
>Table2.id
>Table2.payment_date
>Table2.payment_amount
>...
>
>Table3 "Contact Info"
>Table3.id
>Table3.family_member_last_name
>Table3.family_member_first_name
> ...
>
>Linking field (obviously) is ID.
>
>We need a select which returns a record for each id,payment_date,payment_amount,family_member_last_name. We need same number of records for each ID as exists in Table2.
>
>We don't want multiple sets of payment_amount caused by having more than one family member in the Table3 contact info.
>
>Currently the SQL selects we've created with Crystal are returning repeatitive sets of payment info - repeating the payment info for each family member.
>
>Thought that DISTINCT might solve our problem but Crystal SQL editor gives syntax error when we try to insert it.
>
>So- can a SQL guru come to our aid?