Query

Marcel Trapman marcel at it2be.com
Tue Sep 30 16:58:15 CDT 2003


Ken,

I have just one table "Transactions" and want to filter out all single 
occurances of, for instance, a customer name.

Ruslan,

  suggested 'SELECT DISTINCT'... And... Thanks for your help. It works!

Thanks,

Marcel

Ken Ray heeft op zaterdag, 27 sep 2003 om 05:39 (Europe/Amsterdam) het 
volgende geschreven:

> Marcel,
>
> What are your tables/fields you're using for this? A table called
> "Customers" linked to a table called "Transactions"? It's hard to
> respond without more information...
>
> Ken Ray
> Sons of Thunder Software
> Email: kray at sonsothunder.com
> Web Site: http://www.sonsothunder.com/
>
>> -----Original Message-----
>> From: valentina-bounces at lists.macserve.net
>> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of
>> Marcel Trapman
>> Sent: Friday, September 26, 2003 5:05 PM
>> To: Valentina Developers
>> Subject: Query
>>
>>
>> Hai list,
>>
>> I need to make a cursor. So far no problem :-)
>>
>> Let's assume I have a vdb filled with 100 records.
>> Let's assume I have a record labelled 'customer'.
>> Let's assume there are 10 customers with 100 transactions.
>>
>> Is there an SQL statement that I can use to filter out only these 10
>> customers to fill a popupmenulist?
>>
>> Thanks,
>>
>> Marcel
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/val> entina
>>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
Met vriendelijke groet,

Marcel J.G. Trapman
IT2Be
Johanna van Gulikstraat 41
4205 GD Gorinchem
Tel.		+31 183 61 76 85
GSM		+31 622 51 99 64
E-mail	marcel at IT2Be.com



More information about the Valentina mailing list