SQL Joins and Limits

[Shadow121]

I Have a query pulling and combining two tables together into one set of data. However, it is pulling all 12 from the one table. I was wondering how I could modify my present query, to get only where the userparts.owner is a person, and limit it to pull only the first 4 it comes from.

"SELECT * FROM medaparts LEFT JOIN userparts ON medaparts.id = userparts.medapart_id;

I've tried patching in LIMIT 4 and a check to make sure the userparts.owner is the person it needs to, but it doesn't work.

Edit: Guess I should've played around some more with it. I got it working.