SELECT PublisherAndTitle.TitleNo, PublisherAndTitle.PublisherNo, Title.TitleName, Title.Imprint, Title.TitleNo, Title.FourLetter, Title.Directory FROM PublisherAndTitle LEFT JOIN Title ON PublisherAndTitle.TitleNo=Title.TitleNo WHERE PublisherAndTitle.PublisherNo = #PublisherNo#