SELECT u.firstName, u.middleName, u.lastName, c.creditID, c.credit FROM tbl_credits c LEFT OUTER JOIN tbl_users u ON u.userID = c.userID

#credit#

#firstName# #middleName# #lastName#