0 votes 0 votes thor asked Jan 7, 2017 thor 525 views answer comment Share Follow See all 11 Comments See all 11 11 Comments reply Show 8 previous comments Kaushik.P.E commented Jan 7, 2017 reply Follow Share select T.pname from project T, project P where T.pname=P.pname and P.duration=3. isnt this correct? 0 votes 0 votes santhoshdevulapally commented Jan 7, 2017 reply Follow Share why ?? 0 votes 0 votes Kaushik.P.E commented Jan 7, 2017 reply Follow Share sorry didn't notice that you've defined the tables twice... But i think this might confuse ppl further. After the assignment both T and P will be tuple variables of the table. this is the general convention. 1 votes 1 votes Please log in or register to add a comment.
1 votes 1 votes Look at the predicate condition. T.pname = P.pname . So T will contain the attribute pname with values that satisfies the condition. Kaushik.P.E answered Jan 7, 2017 Kaushik.P.E comment Share Follow See all 0 reply Please log in or register to add a comment.