Re: BillMax questions -- Reports by zip code

["Leland J. Steinke" <steinkel@pa.net>]

Kent Andersen wrote:
> This is cool. so what would be the modification for listing them by 
> name, address and service?

SELECT servdef.name, service.d01, ELT(state+1, 'OPEN', 'CLOSED', 
'SUSPENDED') as status, user.lname, user.fname, user.addr1, user.city, 
user.statename, user.zip FROM user, service, servdef WHERE user.number = 
service.user AND service.servdef = servdef.number AND service.state IN (0,2)

There are a number of good reference books for writing SQL queries. The 
BillMax documentation explains all the columns in all the tables quite 
well.  Go forth and learn.  Shun the frumious Cartesian Product!


Leland
-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.