SELECT b.BusinessID, b.BusinessName, b.IsPrivate, b.Region, b.CoordX, b.CoordY, b.CoordZ, b.OwnerKey, a.Name FROM Businesses b LEFT JOIN Avatars a ON b.OwnerKey = a.AvKey

Add a business

BusinessID: #GetBiz.BusinessID#
Private #GetBiz.BusinessName#
Owned by: key=#GetBiz.OwnerKey# #GetBiz.Name#
Headquarters: #GetBiz.Region# (#GetBiz.CoordX#, #GetBiz.CoordY#, #GetBiz.CoordZ#)