<0> maxim rows <1> Zarta, it is in the documentation the limit is size of table <0> ok <1> Zarta that is dependent on the maximum file size of your operating system and the available space on said operating system
<2> SELECT c.ContactTypeID,c.Prefix,c.FirstName,c.LastName,Suffix,c.NickName,c.StatusID,IFNULL(u.UserName,'No User Account') FROM dat_Contact c LEFT JOIN dat_User u ON c.ContactID = u.ContactID WHERE c.ContactID = 6 AND c.StatusID = 1 <- should return all results found in dat_contact and fill in NULL for anything not found matching in dat_user