Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal SQL select question
Message
From
10/07/2000 03:18:44
Walter Meester
HoogkarspelNetherlands
 
 
To
10/07/2000 00:17:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00390089
Message ID:
00390102
Views:
13
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform