I have a user table and an object table (for project and properties at
the moment). I can get a list of all my Project Objects with the user
that created them by doing this...
select * from tbl_object join tbl_user on tbl_user.user_id =
tbl_object.created_by where object_type = 1 #1 being project type
Now, technically a User is also an object (as is just about everything
else in our application), but how efficient is it to have 'everything'
in the one table and keep joining that to itself?
select * from tbl_object tbl_object_project
join tbl_object tbl_object_user on ...