Getting Activites and Comments help

[Community Alums]

I have a query that will see if the last 10 days has had any comments.  Now I have a requirement that they want to also see if anyone has replied via email to the sctask. 

I know the following tables hold this info:

Comments:  sys_journal_field

Activity information: sys_history_line

List of Activities:  sys_history_set

So I need to somehow join the sys_journal_field, sys_history_set and sys_history_line table in a glide record query and then beable to run some IF Else statements against that.  I have the logic I need but now sure how to join the tables in a GlideRecord query. 

Could someone show or provide an example of this?  I'm not sure which should be the parent table, maybe the sys_journal_field, but I think the other two tables

Thougths or suggestions or sample code?

[Saurav11]

Hello

Sys journal sould probably be yur parent as yu will get most info from their itself annd the you can glide fr remaining

Please mark answer correct/helpful based on impact

[Community Alums]

Ok, that makes sense but I need to know how to put the 3 tables together