if i need to do a single query and the result will be shared for 3 field... it wouldn't be possible, right ?
Let say the main query is "SELECT id, title, catid from #__content where created_by=$user->id "
with SQL Pack, i need to build 3 query, right ?
"SELECT id from #__content where created_by=$user->id LIMIT 1"
"SELECT title from #__content where created_by=$user->id LIMIT 1"
"SELECT catid from #__content where created_by=$user->id LIMIT 1"
It will be resource efficient if i create single query and use by those 3 field, right ? is it possible ?