Sql

create table tag_post_answer_map_p*

create table tag_post_answer_map_p9 as select p2 . *, p.parentId as a_parentId, p.creationDate as a_creationDate, p.score as a_score, p.viewCount as a_viewCount, p.body as a_body, p.ownerUserId as a_ownerUserId, p.OwnerDisplayName as a_OwnerDisplayName, p.LastEditorUserId as a_LastEditorUserId, p.LastEditDate as a_LastEditDate, p.LastEditorDisplayName as a_LastEditorDisplayName, p.LastActivityDate as a_LastActivityDate, p.Title as a_Title, p.CommentCount as a_CommentCount, p.FavouriteCount as a_FavouriteCount, p.ClosedDate as a_ClosedDate, p.CommunityOwnedDate as a_CommunityOwnedDate from posts p inner join tag_post_map_p9 p2 ON (p2.acceptedanswerid = p.id)