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 clause, I got the rest, I was just looking for another way. Thanks, E. _______________________________________________ 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.
