Eurico,
Are you using VFP9? If the answer is yes then you can make the value of a
field a SQL statement in its own right:
Select all ;
(select <fname> from <cursor> where <where>) as Field A, ;
...
..
This would do the job. Sorry can't sort it out just now as I have to dash,
but I hope you get the idea.
Dave Crozier
The secret to staying young is to live honestly, eat slowly, and to lie
about your age
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Eurico
Sent: 30 October 2006 16:56
To: 'ProFox Email List'
Subject: SQL statement
Hi Dave
It's something like this. I have to join three tables, all three have
supplier and card. One table has selected supplier and card, the other two
must be joinned to this one, but must show the client and its quantities.
When the client is the same, the two qtds must be shown in one line.
One select, selected table sA.
Than i used a select to get tables sA, sB and sC, where they match,
supplier+card+client. Next using a select with a union and a NOT IN
supplier+card+clause,
I got the rest, I was just looking for another way.
Thanks, E.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
