[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: locating services using SQL



Yes.  That is correct.

On 5/4/07, Charley Tiggs <..hidden..> wrote:
LSMB 1.2.4

Is there anything in particular that I need to check for when locating
services using SQL?  Here's the SQL statement I have currently:

SELECT id, partnumber, description
FROM parts
WHERE inventory_accno_id IS NULL;

This appears to return all services but am wondering if it really is
that simple.  :)

Charley

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel