Advice req. / foreword by majorette

I'll keep this short. Looking for advice on slr's and lenses which give beautiful studio results, and not to expensive. I'm doing some thinking. Thankyou