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

locating services using SQL

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. :)