Thanks Mark just came to that conclusion and then saw your email. Bob S
> On May 15, 2015, at 11:14 , Mark Stuart <mfstuart...@gmail.com> wrote: > > 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 > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode