Re: [Emerald] I need a query

Dan Tang ( (no email) )
Fri, 18 Feb 2000 00:12:50 +0800

select ma.customerid,ma.lastname,ma.firstname,inv.Invoiceid from invoices
inv, masteraccounts ma where inv.customerid=ma.customerid and type='void'
and inv.date>'11/2/99'

-----Original Message-----
From: Duane Schaub <dschaub@terraworld.net>
To: Emerald List <emerald@iea-software.com>
Date: Friday, February 18, 2000 12:05 AM
Subject: [Emerald] I need a query

>Anyone, please help: (SQL7)
>
>I need a query to list customerid, lastname, firstname, (most recent
>non-void invoice)
>
>
>
>
>
>======================================================================
>Duane Schaub, President |Terra World, Inc - Connecting The Planet
>Terra World, Inc. |Southeast Kansas' Leading Provider
>200 Arco Place, Suite 252 |Flat Fee - Never an hourly Charge
>Independence, Kansas 67301 |Where Service is Top Priority!
>Voice (316) 332-1616 |http://www.terraworld.net
>FAX: (316) 332-1451 |dschaub@terraworld.net
>======================================================================
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart