thanks for answering, but this is something a bit different than what I wanted. i just want to call the posts from blogs to appear in the main site, something just like rss. i do not want to copy the content or recreate it.
the problem is that RSS would only show the title of the post, but i want the title, the excerpt, and some custom field values to show up from the blogs in the main site.
like this peace of code that i have in my template which works fine with the main site, but the different is that I want it to get content from a blog not the main site. since the main site and the blogs are in the same database with just different table prefix i think this should be possible.
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php the_title(); ?>
<a href="<?php the_permalink() ?>"><img src="<?php echo get_post_meta($post->ID, 'thumb',true); ?>" />
<?php the_excerpt(); ?>
<?php endwhile; else: ?><?php endif; ?>