how to join two tables [modified]

[harithadotnet]

Hi I created two tables in my database as topcs(topicid,topic,createdate,authorname) posting(postid,content,postcreatename,postdate,topicid) now i want to display all records in topics and( number of posts ,last post name, last post date) of each topic how to write query for this plz help me -- modified at 1:38 Thursday 5th July, 2007

Haritha

[Krish KP]

can you pls provide sample data for these tables

Regards KP