Urgent!, urgent!, emerrrgency! creating two separate querys and passing their results to a view file

[eluser]prog_boy[/eluser]

I really like cookies and milk while i post to my blog!
Posted on wednesday Aug 9th, 2006 @ 5:20PM -by Prog Boy

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent aliquam, justo convallis luctus rutrum, erat nulla fermentum diam, at nonummy quam ante ac quam. Maecenas urna purus, fermentum lacus...

As you can see from the text above, that is what the goal of my query is. In my controller I want to select everything from the blogs table and the members table. I want to echo the results from the blog table in my view file(i.e $blog->title,dateposted,author, etc...), i want the name field of the members table to be echo in the view file where the blogs member id field is equals to the member id field on the members table. how do i go about this CI? this problem has almost brought me to tears, it's so frustrating > that i feel like giving up.