id from one table showing value from another

[deadlyhifi]

I have an article id (rs_comments.id_com) but I would like it to take this data and collect the value from another table.

I have joined the two tables with:
SELECT * FROM blg_comment_com INNER JOIN blg_article ON idart_com=id_art
WHERE valid_com=1
ORDER BY date_com DESC

rs_comments.idart_com needs to be equal to rs_comments.id_art displaying the value from rs_comments.title_art

How would I go about doing this. There only seems to be an option in DW to do this with a dynamic list/menu but I just want to display the text without option to change it.

Any help much appreciated.

[deadlyhifi]

i was stupid. The answer was staring me in the face. No wonder no-one bothered to reply...