--- Steve Harp <[EMAIL PROTECTED]> wrote: > HI All, > > > > I'm trying to get invoice totals to show item totals and payments. I > have 3 > tables; Invoice, InvoiceDetail, and InvoicePayment. I first tried a > join > like this. > > [..]
I haven't tried it in NET, but am venturing a guess that this has to do with parameters. Can you try to remove the parameters from the SQL statement and see if it works. -Steve ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider