run two queries one return

[eluser]tim1965[/eluser]
Thanks for the replies

My problem is i already have a large and complex search query using active records that uses a lot of joins already. I wanted to add another table and run a $this->db->select_min and max on it. But the query is failing when i use this as it doesnt like the join syntax for the table when i specify the field. I will try both options(assuming the plane ever takes off), and let you know. I suspect the last option will be closer to what i am trying to achieve. thanks again.