Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Join question |
Fri, Feb 3 2006 6:05 PM | Permanent Link |
Carlos | Need an sql
Table1 invoices invoiceNum ClientNum 1 A 2 A 3 B 4 C 5 D Table2 transactions Client TransDate A 01-01-2001 A 02-01-2001 C 02-01-2001 Need this result all transactions with the InvoiceNumber No duplicate on InvoiceNumber where the cliente are the same InvNum Client Date 1 A 01-01-2001 2 A 01-01-2001 4 C 02-01-2001 Carlos |
Mon, Feb 6 2006 11:29 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Carlos,
<< Need this result all transactions with the InvoiceNumber No duplicate on InvoiceNumber where the cliente are the same >> I think you've got a design issue here. Shouldn't the invoice number be in the transactions table, not the client number ? -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |