Hi all,
I am trying to create SQL query with multiple joins (2 to start with) and I know from access that I have to creata first one join in one query and then use that query with another join. But how do I do this in SQL (I have to send SQL request to my Access DB from a webpage, so I have to write it dones as SQL. In access it gives me that result:
SELECT Query1.movie_title, Query1.movie_year, Query1.genre_id, tbl_users_comments.comment
FROM Query1 LEFT JOIN tbl_users_comments ON Query1.movie_id=tbl_users_comments.movie_id;
So I have already here Query1 which was created before. How can I do it all query1 and query2 (main big query) in one SQL query?
Thanks
I am trying to create SQL query with multiple joins (2 to start with) and I know from access that I have to creata first one join in one query and then use that query with another join. But how do I do this in SQL (I have to send SQL request to my Access DB from a webpage, so I have to write it dones as SQL. In access it gives me that result:
SELECT Query1.movie_title, Query1.movie_year, Query1.genre_id, tbl_users_comments.comment
FROM Query1 LEFT JOIN tbl_users_comments ON Query1.movie_id=tbl_users_comments.movie_id;
So I have already here Query1 which was created before. How can I do it all query1 and query2 (main big query) in one SQL query?
Thanks