Here is the sql statement I used:
| insert into nuke_news_stories (state,story_id,summary,ext_text,title, views,create_date,author_id,topic_id) | select pn_state,pn_sid,pn_hometext,pn_bodytext,pn_title,pn_counter,pn_time,pn_uid,pn_topic from nuke_stories, nuke_users | where nuke_users.pn_uname=nuke_stories.pn_informant; | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3837669#3837669 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3837669 ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development