SPJ query – Selection, Projection and Join where Selection selects a row of a relation based on a condition, projection selects columns/attributes from a relation and Join is a standard join on a condition. I also include the Renaming operator which just renames an attribute name to another name.
I want to find a proof that shows I can translate any such query into a simple select SQL query which only uses Distinct in the select clause and and from and where clause using only AND in the where clause.
These definitions match those in Ramakrishnan & Gehrke