[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
locating services using SQL
- Subject: locating services using SQL
- From: Charley Tiggs <..hidden..>
- Date: Fri, 04 May 2007 11:11:31 -0400
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