Sample query in Inner Join (Teradata)?...

Model 1:

Select A.MovieName, B.ActorName

From Movie_List A 

Inner Join Actor_List B

On (A.Movie_No = B. Movie_No);

Model 2:

Select A.MovieName, B.ActorName

From Movie_List A 

Join Actor_List B

On (A.Movie_No = B. Movie_No);

Model 3:

Select A.MovieName, B.ActorName

From Movie_List A, Actor_List B

where A.Movie_No = B. Movie_No

And A.Movie_No = 1;