2 votes 2 votes Assume i have two tables R(A,B) and S(A,D) 1. Select * from R,S 2. Select * from R,S where R.A>S.A What will be the name/number of columns on both of these cases? Databases databases sql + – rahul sharma 5 asked Jul 13, 2017 • retagged Aug 5, 2017 by Arjun rahul sharma 5 535 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply Show 2 previous comments joshi_nitish commented Jul 13, 2017 reply Follow Share now also in both cases you will get 4 columns (R.A , B , S.A , D)...because 'from' operator(SQL) work just like cross product(Relational algebra)... 0 votes 0 votes G Shaheena commented Jul 14, 2017 reply Follow Share when query executed 4 columns are possible because it gives cross product 0 votes 0 votes student2018 commented Sep 3, 2017 reply Follow Share when i execute this query i got 3 coloumns in both cases with different number of rows 0 votes 0 votes Please log in or register to add a comment.