please write as much as possible of join operators for this sample with a discription using sql

\begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ login_history } \\ \hline FK & \( \begin{array}{c}\text { login_datetime } \\ \text { user_id }\end{array} \) \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ web_user } \\ \hline PK & user_id \\ first_name \\ last_name \\ email_address \\ active \\ signup_datetime \\ profile_image_name \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ site_post } \\ \hline PK & post_id \\ FK & user_id \\ & post_datetime \\ & post_text \\ \hline \end{tabular}