text to sql syntaxTue, 24 Jan 2023

query that returns all rows from Posts table and all rows from Categories Table Where post_category Column From Posts Table is equal to category_id Column From Categories Table and all rows from Views Table Where post_id Column from Posts Table is equal to post_id from Column Views Table

SELECT * FROM Posts, Categories, Views WHERE post_category=category_id AND post_id=post_id;

Questions about programming?Chat with your personal AI assistant