sample-two

Column "Writers Name" format a25;

select tw.WriterFName||' '||tw.WriterLName as "Writers Name"
    from tblWriter tw
        left outer join tblWriterDetail twd on tw.WriterID = twd.WriterID
    where twd.MovieID is null
    order by tw.WriterID;
/*
Writers Name
-------------------------
Ben Hecht
Christopher Nolan
Walon Green
Sam Peckinpah
Nunnally Johnson
Frank S. Nugent
Sidney Carroll
Robert Rossen
Woody Allen
Francis Ford Coppola
Edmund H. North
Writers Name
-------------------------
Joseph Stefano
David Mamet
Alexander Payne
Jim Taylor
Eric Roth
Phil Alden Robinson
Federico Fellini
Brunello Rondi
Tullio Pinelli
Ennio Flaiano
Colin Higgins
Writers Name
-------------------------
Jean Renoir
Charles Spaak
William Goldman
John Michael Hayes
Donn Pearce
Frank Pierson
Jerzy Kosinski
Earl W. Wallace
William Kelley
Mel Brooks
Sylvester Stallone
Writers Name
-------------------------
Charlie Kaufman
Donald Kaufman
Paul Schrader
Mardik Martin
Carl Foreman
George Lucas
Cameron Crowe
Betty Comden
Adolph Green
James L. Brooks
Peter Benchley
Writers Name
-------------------------
Carl Gottlieb
Ted Tally
Robert Zemeckis
Bob Gale
48 rows selected.
*/