![]() ![]() | notif_id | da | uft_id | un | tr_n | cm_tx | av_ul | The result of that query is like this: +-+-+-+-+-+-+-+ LEFT JOIN tricks trickComment_tricks ON trickComment_id = trickComment_id LEFT JOIN users trickComment_users ON trickComment_users.u_id = trickComment_userForTricks.u_id On trickComment_userForTricks.uft_id = notif_trick_comment.uft_id LEFT JOIN user_for_tricks trickComment_userForTricks LEFT JOIN notif_trick_comment ON notif_trick_comment.notif_id = notif_dest_user.notif_id LEFT JOIN users like_users ON like_userForTricks.u_id = like_users.u_id LEFT JOIN tricks like_tricks ON like_id = like_id LEFT JOIN user_for_tricks like_userForTricks ON notif_trick_like.uft_id = like_userForTricks.uft_id LEFT JOIN notif_trick_like ON notif_dest_user.notif_id = notif_trick_like.notif_id LEFT JOIN notif_all ON notif_all.notif_id = notif_dest_user.notif_id My query sample: SELECT notif_dest_user.notif_id,ĬOALESCE(notif_trick_like.uft_id, notif_trick_comment.uft_id) AS uft_id,ĬOALESCE(like_users.un, trickComment_users.un) AS un,ĬOALESCE(like_n, trickComment_n) AS tr_n,ĬOALESCE(trickComment_users.av_ul,like_users.av_ul) AS av_ul But as I want to join one with another tables, I have to use LEFT JOIN. I want to JOIN a base table with another 23 tables. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |