Hi Bob, LEFT OUTER JOIN will given you every record on the left (devices) even if a device has no accessory.
Mark _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
