View Example:

"Author, Title, Room Number and URL for all paintings in the Uffizi Web Site"


DEFINE TABLE UffiziPaintings (Author,Title,RoomNumber,PageURL)
AS           RoomsPage.RoomList.ToRoom -> 
             RoomPage.PaintList
IN           UffiziScheme
USING        RoomPage.PaintList.Painter, 
             RoomPage.PaintList.Title,
             RoomPage.RoomNo, 
             RoomPage.PaintList.ToPaint
WHERE

Here is the resulting table.

Result of Ulixes query

UffiziPaintings
Author	Title	RoomNumber	PageURL
Bonaventura Berlinghieri (school of)	Madonna with Child and Saints, The Crucifixion	2	NULL
Cimabue	Santa Trinita Madonna	2	http://www.uffizi.firenze.it/Dipinti/cimstriE2.html
Giotto	Ognissanti Madonna	2	http://www.uffizi.firenze.it/Dipinti/giotogniE2.html
Giotto	The Badia Polyptych	2	NULL
Duccio di Boninsegna	Rucellai Madonna	2	NULL
Master of San Francesco Bardi	Stigmata of Saint Francis	2	NULL
Master of the Maddalena	Saint Luca the Evangelist	2	NULL
Master of San Torpè	Madonna with Child	2	NULL
Meliore di Jacopo	The Saviour with four Saints	2	NULL
Florentine Artist of the mid-13th Century	Madonna with Child	2	NULL
Luccan Artist of the mid-13th Century	Crucifix with scenes of the Passion	2	NULL
Pisan Artist of the late 12th Century	Crucifix with scenes of the Passion	2	NULL
Pietro Lorenzetti	The Virgin enthroned with Child and Angels	3	http://www.uffizi.firenze.it/Dipinti/pietlormadE3.html
Pietro Lorenzetti	Beata Umiltà Altarpiece	3	NULL
Ambrogio Lorenzetti	Four scenes from the Life of Saint Nicholas	3	NULL
Ambrogio Lorenzetti	The Presentation in the Temple	3	NULL
Ambrogio Lorenzetti	Madonna with Child and Saints	3	NULL
Niccolò di Bonaccorso	The Presentation of the Virgin in the Temple	3	NULL
Simone dei Crocefissi	Nativity	3	NULL
Niccolò di Ser Sozzo Tegliacci	Madonna with Child	3	NULL
Simone Martini and Lippo Memmi	The Annunciation and two Saints	3	http://www.uffizi.firenze.it/Dipinti/smartiannuE3.html
Bernardo Daddi	Madonna and Child with SS. Matthew and Nicholas	4	NULL
Bernardo Daddi	The Virgin enthroned with Child, Angels and Saints	4	NULL
Bernardo Daddi	San Pancrazio Polyptych	4	NULL
Taddeo Gaddi	The Virgin enthroned with Child	4	NULL
Jacopo del Casentino	The Virgin enthroned with Saints	4	NULL
Giottino	Pietà	4	http://www.uffizi.firenze.it/Dipinti/giottipietE4.html
Giovanni da Milano	Ognissanti Polyptych	4	NULL
Saint Cecilia Master	Saint Cecilia and scenes from her Life	4	NULL
Nardo di Cione	Crucifixion	4	NULL
Pacino di Bonaguida (workshop of)	Crucifix and Saints	4	NULL
Andrea Orcagna and Jacopo di Cione	Saint Matthew and scenes from his Life	4	http://www.uffizi.firenze.it/Dipinti/orcagmattE4.html
Jacopo Bellini	Madonna with Child	5/6	NULL
Gentile da Fabriano	Adoration of the Magi	5/6	http://www.uffizi.firenze.it/Dipinti/gentiladorE5.html
Gentile da Fabriano	Four Saints from the Quaratesi Polyptych	5/6	http://www.uffizi.firenze.it/Dipinti/gentquar5.html
Lorenzo di Pietro, called il Vecchietta	The Virgin enthroned with Saints	5/6	NULL
Nicola di Guardiagrele	Madonna with Child and Angels	5/6	NULL
Agnolo Gaddi	The Crucifixion	5/6	NULL
Giovanni di Paolo	Madonna with Child and Saints	5/6	NULL
Lorenzo Monaco and Cosimo Rosselli	Adoration of the Magi	5/6	http://www.uffizi.firenze.it/Dipinti/loreadoraE5.html
Beato Angelico	The Thebaid	5/6	http://www.uffizi.firenze.it/Dipinti/angeltebE5.html
Masolino da Panicale	Madonna of Humility	5/6	NULL
Lorenzo Monaco	Coronation of the Virgin	5/6	http://www.uffizi.firenze.it/Dipinti/lormonincoE5.html
Beato Angelico	Coronation of the Virgin	7	http://www.uffizi.firenze.it/Dipinti/beatoincorE7.html
Beato Angelico	Madonna with Child and Saints	7	NULL
Domenico Veneziano	Santa Lucia dei Magnoli Altarpiece	7	http://www.uffizi.firenze.it/Dipinti/venezluciaE7.html
Piero della Francesca	Portraits of Federico da Montefeltro, Duke of Urbino, and his Wife	7	NULL
Paolo Uccello	The Battle of San Romano	7	http://www.uffizi.firenze.it/Dipinti/uccelbattE7.html
Masaccio	Madonna with Child	7	NULL
Masaccio and Masolino	The Virgin and Child with Saint Anne	7	http://www.uffizi.firenze.it/Dipinti/masmadE7.html
Sandro Filipepi, called il Botticelli	Fortitude	9	NULL
Piero Benci, called del Pollaiolo	Charity	9	NULL
Piero del Pollaiolo	Faith	9	NULL
Piero del Pollaiolo	Justice	9	NULL
Piero del Pollaiolo	Prudence	9	NULL
Piero del Pollaiolo	Hope	9	NULL
Piero del Pollaiolo	Temperance	9	NULL
Piero del Pollaiolo	Portrait of Galeazzo Maria Sforza	9	http://www.uffizi.firenze.it/Dipinti/pollsforzaE9.html
Jacopo del Sellaio	Ahasuerus's Banquet	9	http://www.uffizi.firenze.it/Dipinti/sellconvE9.html
Lorenzo di Credi	Portrait of a Young Man	9	NULL
Antonio Benci, detto del Pollaiolo	Hercules and Antaeus	9	http://www.uffizi.firenze.it/Dipinti/pollercanteoE9.html
Antonio del Pollaiolo	Hercules and the Hydra	9	http://www.uffizi.firenze.it/Dipinti/pollercidrE9.html
Antonio del Pollaiolo	Portrait of a Woman	9	NULL
Antonio e Piero del Pollaiolo	Altarpiece of the SS. Vincent, James and Eustace	9	http://www.uffizi.firenze.it/Dipinti/polltresantiE9.html
Sandro Botticelli	The Return of Judith	9	http://www.uffizi.firenze.it/Dipinti/botgiudiE9.html
Sandro Botticelli	The Discovery of the Murder of Holophernes	9	http://www.uffizi.firenze.it/Dipinti/botolofE9.html
Sandro Botticelli	Madonna of the Rosengarden	10/14	http://www.uffizi.firenze.it/Dipinti/botrosetoE10.html
Sandro Botticelli	Magnificat Madonna	10/14	http://www.uffizi.firenze.it/Dipinti/botmagnE10.html
Sandro Botticelli	Madonna with Child	10/14	NULL
Sandro Botticelli	The Birth of Venus	10/14	http://www.uffizi.firenze.it/Dipinti/botveneE10.html
Sandro Botticelli	Pallas and the Centaur	10/14	NULL
Sandro Botticelli	Madonna of the Pomegranate	10/14	http://www.uffizi.firenze.it/Dipinti/botmelagE10.html
Sandro Botticelli	Calumny	10/14	NULL
Sandro Botticelli	The Annunciation	10/14	http://www.uffizi.firenze.it/Dipinti/botannuncE10.html
Sandro Botticelli	Allegory of Spring	10/14	http://www.uffizi.firenze.it/Dipinti/botprimE10.html
Sandro Botticelli	Adoration of the Magi	10/14	http://www.uffizi.firenze.it/Dipinti/botmagiE10.html
Sandro Botticelli	Portrait of a Man with the Medal of Cosimo the Elder	10/14	http://www.uffizi.firenze.it/Dipinti/bottmedaglE10.html
Sandro Botticelli	Sant'Ambrogio Altarpiece	10/14	http://www.uffizi.firenze.it/Dipinti/bottambE10.html
Sandro Botticelli	Saint Augustin in his Cell	10/14	NULL
Sandro Botticelli	San Marco Altarpiece with five stories of Saints	10/14	NULL
Sandro Botticelli	San Barnaba Altarpiece	10/14	NULL
Domenico Bigordi, called il Ghirlandaio	The Virgin enthroned with Saints	10/14	NULL
Domenico Ghirlandaio	Madonna with Child and Saints	10/14	NULL
Domenico Ghirlandaio	Adoration of the Magi	10/14	NULL
Hugo van der Goes	Portinari Triptych	10/14	http://www.uffizi.firenze.it/Dipinti/trittportE10.html
Leonardo da Vinci	The Annunciation	15	http://www.uffizi.firenze.it/Dipinti/leoannuncE15.html
Leonardo da Vinci	Adoration of the Magi	15	NULL
Verrocchio and Leonardo da Vinci	The Baptism of Christ	15	http://www.uffizi.firenze.it/Dipinti/verrbattE15.html
Perugino	Madonna with Child and Saints	15	http://www.uffizi.firenze.it/Dipinti/perugmadE15.html
Perugino	Pietà	15	NULL
Perugino	Agony in the Garden	15	NULL
Perugino	Crucifixion with Saints	15	NULL
Piero di Cosimo	The Immaculate Conception	15	NULL
Luca Signorelli	Crucifix with Mary Magdalen	15	NULL
Luca Signorelli	The Holy Trinity, the Virgin and Saints, Predella with scenes from the Life of Jesus	15	NULL
Lorenzo di Credi	Adoration of the Shepherds	15	NULL
Alessandro Allori	Portrait of Bianca Cappello	18	NULL
Carlo Caliari	Original Sin	18	NULL
Carlo Caliari	Creation of Eve	18	NULL
Carlo Caliari	The Expulsion from Earthly Paradise	18	NULL
Carlo Caliari	Adam's Family	18	NULL
Andrea del Sarto	Portrait of a Woman with the 'Petrarchino'	18	NULL
Agnolo Bronzino	Portrait of Bartolomeo Panciatichi	18	http://www.uffizi.firenze.it/Dipinti/bronzbartpanE18.html
Agnolo Bronzino	Portrait of Lucrezia Panciatichi	18	http://www.uffizi.firenze.it/Dipinti/bronzlucreE18.html
Agnolo Bronzino	Portrait of Bia de' Medici	18	NULL
Agnolo Bronzino	Portrait of a Man with a Lute	18	NULL
Agnolo Bronzino	Portrait of Eleonora di Toledo with her Son Giovanni	18	http://www.uffizi.firenze.it/Dipinti/bronzeleE18.html
Agnolo Bronzino	Portrait of Giovanni de' Medici	18	http://www.uffizi.firenze.it/Dipinti/bronzgarciaE18.html
Pontormo	Madonna with Child with the Infant Saint John	18	NULL
Pontormo	Portrait of Cosimo the Elder de' Medici	18	NULL
Daniele da Volterra	The Massacre of the Innocents	18	NULL
Agnolo Bronzino	Portrait of Cosimo I	18	http://www.uffizi.firenze.it/Dipinti/bronzcosE18.html
Agnolo Bronzino	Portrait of a Woman with a book	18	NULL
Agnolo Bronzino	Portrait of Maria de' Medici	18	http://www.uffizi.firenze.it/Dipinti/bronzmariaE18.html
Agnolo Bronzino	Portrait of Francesco I de' Medici	18	http://www.uffizi.firenze.it/Dipinti/bronzfranE18.html
Agnolo Bronzino	Annunciation	18	NULL
Giorgio Vasari	Portrait of Lorenzo the Magnificent	18	NULL
Franciabigio	Madonna of the Well	18	NULL
Ridolfo del Ghirlandaio	Portrait of a Man	18	NULL
Rosso Fiorentino	Musician Angel	18	http://www.uffizi.firenze.it/Dipinti/rosangE18.html
Giulio Romano	Madonna with Child	18	NULL
Raffaello Sanzio	Saint John the Baptist in the Desert	18	http://www.uffizi.firenze.it/Dipinti/raffsangiovE18.html
Francesco Salviati	Charity	18	NULL
Francesco Salviati	Christ Bearing the Cross	18	NULL
Pontormo (attr.)	Leda and the Swan	18	NULL
Pontormo	Adam and Eve	18	NULL
Giorgio Vasari	Allegory of the Immaculate Conception	18	NULL
Giorgio Vasari	The Prophet Elisha	18	http://www.uffizi.firenze.it/Dipinti/vasaelisE18.html
Lorenzo Costa	Saint Sebastian	19	NULL
Girolamo Genga	The Martyrdom of Saint Sebastian	19	NULL
Lorenzo di Credi	Venus	19	NULL
Lorenzo di Credi	Annunciation	19	NULL
Francesco Raibolini, called il Francia	Portrait of Evangelista Scappi	19	NULL
Lorenzo di Alessandro da Sanseverino	Pietà	19	NULL
Marco Palmezzano	The Crucifixion	19	NULL
Perugino	Portrait of Francesco delle Opere	19	http://www.uffizi.firenze.it/Dipinti/perugfranc19.html
Perugino	Portrait of a Man	19	NULL
Perugino	Portrait of Don Biagio Milanesi	19	NULL
Perugino	Portrait of Baldassarre vallombrosano	19	NULL
Piero di Cosimo	Perseus Frees Andromeda	19	NULL
Luca Signorelli	The Holy Family	19	NULL
Luca Signorelli	Madonna with Child	19	NULL
Luca Signorelli	Allegory of Fertility and Abundance	19	NULL
Lukas Cranach the Elder	Adam	20	http://www.uffizi.firenze.it/Dipinti/cranadamE20.html
Lukas Cranach the Elder	Eve	20	NULL
Lukas Cranach the Elder (workshop of)	Portraits of Martin Lutero and his wife Catherin Bora	20	NULL
Lukas Cranach the Elder (workshop of)	Portrait of a Woman	20	NULL
Lukas Cranach the Elder (workshop of)	Portraits of Friedrick III the Wise and Johann I, Electors of Saxony	20	NULL
Lukas Cranach the Elder (workshop of)	Portraits of Martin Luther and Philipp Melanchthon	20	http://www.uffizi.firenze.it/Dipinti/cranlutmelE20.html
Lukas Cranach the Younger	Portrait of Lukas Cranach the Elder	20	NULL
Hans Baldung Grien	Adam	20	NULL
Hans Baldung Grien	Eve	20	NULL
Hans Maler zu Schwaz	Portrait of Ferdinand of Castille	20	NULL
Georg Lemberger	Saint George Frees the Princess	20	NULL
Albrecht Dürer	Madonna and Child with a Pear	20	NULL
Albrecht Dürer	Calvary	20	NULL
Albrecht Dürer	The Apostle Saint James	20	NULL
Albrecht Dürer	Adoration of the Magi	20	NULL
Albrecht Dürer	Portrait of the Artist's Father	20	NULL
Albrecht Dürer	The Apostle Saint Philip	20	NULL
German School of the 16th Century	Open Book	20	NULL
Hans Suss von Kulmbach	Scenes from the Life of Saints Peter and Paul	20	NULL
Hans Suss von Kulmbach	The Crucifixion with Mary Magdalen	20	NULL
Joos van Clève	Portrait of a Man	20	NULL
Jan Brueghel the Elder	Calvary	20	NULL
Hans Burgkmair	Portrait of a Man	20	NULL
Giovanni Bellini	Sacred Allegory	21	http://www.uffizi.firenze.it/Dipinti/bellallegE21.html
Giovanni Bellini	Portrait of a Young Man	21	NULL
Giovanni Bellini	The Lamentation over the Dead Christ	21	http://www.uffizi.firenze.it/Dipinti/bellicristE21.html
Vittore Carpaccio	Prophet	21	NULL
Vittore Carpaccio (attr.)	Sibyl	21	NULL
Vittore Carpaccio (attr.)	Soldiers and Men	21	NULL
Giorgione	Portrait of Warrior with his Equerry	21	http://www.uffizi.firenze.it/Dipinti/giorgioguerE21.html
Giorgione	The Judgement of Solomon	21	NULL
Giorgione	The Infant Moses before Pharaon Undergoes Trial by Fire	21	NULL
Cosmè Tura	Saint Dominic	21	NULL
Giovanni Battista Cima da Conegliano	Madonna with Child	21	NULL
Bartolomeo Vivarini	Saint Louis of Toulouse	21	NULL
Lorenzo Costa	Portrait of Giovanni Bentivoglio	21	NULL
Albrecht Altdorfer	The Departure of Saint Florian	22	NULL
Albrecht Altdorfer	Martyrdom of Saint Florian	22	NULL
Hans Holbein the Younger	Portrait of Sir Richard Southwell	22	NULL
Hans Holbein the Younger	Self-Portrait	22	NULL
Hans Holbein the Younger	Portrait of a Man, thought to be Tommaso Moro	22	NULL
Master of Baroncelli Portraits	Portraits of Pierantonio Baroncelli and Maria Bonciani	22	NULL
Luca di Leida (attr.)	The Mocking of Christ	22	NULL
Master of Hoogstraeten	Madonna with Child and Saints	22	NULL
Gerard David	Adoration of the Magi	22	NULL
Hans Memling	The Virgin enthroned with Child and two Angels	22	http://www.uffizi.firenze.it/Dipinti/memlmadE22.html
Hans Memling	Portrait of a Man	22	NULL
Hans Memling	Saint Benedict	22	NULL
Hans Memling	"Mater dolorosa"	22	NULL
Hans Memling	Portrait of Benedetto Portinari	22	NULL
Georg Pencz	Portrait of a Young Man	22	NULL
Bernaert van Orley	Portrait of a Man and his Wife	22	NULL
Master of the 'Virgo inter Virgines'	Crucifixion	22	NULL
Joos van Clève	Portrait of a Man and his Wife	22	NULL
Alessandro Araldi	Portrait of Barbara Pallavicino	23	NULL
Boccaccio Boccaccino	The Gipsy	23	NULL
Giovanni Antonio Boltraffio	Narcissus at the Fountain	23	NULL
Vincenzo Foppa	Madonna and Child with an Angel	23	NULL
Correggio	The Virgin adoring the Child	23	http://www.uffizi.firenze.it/Dipinti/corrverginE23.html
Correggio	Rest during the Flight into Egypt	23	NULL
Correggio	The Virgin with Child in Glory	23	NULL
Bernardino Luini	Herodias	23	http://www.uffizi.firenze.it/Dipinti/luinierodiE23.html
Bernardino de'Conti	Portrait of a Man	23	NULL
Giovanni Ambrogio de'Predis	Portrait of a Man	23	NULL
Giampietrino	Saint Catherine of Alexandria	23	NULL
Francesco Maineri	Christ bearing the Cross	23	NULL
Unknown Painter Leonardesque	Leda	23	NULL
Giovanni Antonio Bazi, called Sodoma	Christ at the Column	23	NULL
Andrea Mantegna	The Madonna of the Caves	23	NULL
Andrea Mantegna	Triptyc with Adoration of the Magi, Circumcision and Ascension	23	NULL
Andrea Mantegna	Portrait of a Man	23	NULL
Giovanni Paolo Pannini	Architectural Freak	24	NULL
Mariotto Albertinelli	The Visitation	25	NULL
Mariotto Albertinelli (attr.)	Portrait of a Woman, called "The Nun"	25	http://www.uffizi.firenze.it/Dipinti/albertmonacaE25.html
Fra' Bartolomeo	Porzia	25	NULL
Fra' Bartolomeo	The Virgin Appears to Saint Bernard	25	NULL
Fra' Bartolomeo	Annunciation, Nativity, Circumcision	25	http://www.uffizi.firenze.it/Dipinti/frabarannunE25.html
Francesco Granacci	Joseph Taken to Prison	25	NULL
Francesco Granacci	Joseph Presents his Father and his Brothers to the Pharaon	25	NULL
Alonso Berruguete	Salomè	25	NULL
Florentine Painter of the first half of 16th Century	Cover for a Portrait	25	http://www.uffizi.firenze.it/Dipinti/anoncopE25.html
Michelangelo	Holy Family (Tondo Doni)	25	http://www.uffizi.firenze.it/Dipinti/michdoniE25.html
Andrea del Sarto	Madonna of the Harpies	26	NULL
Andrea del Sarto	Portrait of Young Woman	26	NULL
Andrea del Sarto	Vallombrosana Altarpiece	26	NULL
Andrea del Sarto	Saint James	26	http://www.uffizi.firenze.it/Dipinti/sartojacoE26.html
Raffaello Sanzio	Portrait of a Man, thought to be Francesco Maria della Rovere	26	NULL
Raffaello Sanzio	Self-Portrait	26	NULL
Raffaello Sanzio	Portrait of Guidubaldo da Montefeltro	26	NULL
Raffaello Sanzio	Portrait of Elisabetta Gonzaga	26	NULL
Raffaello Sanzio	Madonna of the Goldfinch	26	NULL
Raffaello Sanzio (attr.)	Portrait of Perugino	26	http://www.uffizi.firenze.it/Dipinti/rafperugE26.html
Raffaello Sanzio e bottega	Portrait of Pope Giulio II	26	http://www.uffizi.firenze.it/Dipinti/raffgiulE26.html
Raffaello Sanzio	Portrait of Pope Leone X with Cardinals Giulio de' Medici and Luigi de' Rossi	26	NULL
Puligo	Portrait of Piero Carnesecchi	26	NULL
Franciabigio	Portrait of Young Man	26	NULL
Giovan Battista Moroni	Portrait of Pietro Secco Suardo	34	NULL
Giovan Battista Moroni	Portrait of the Poet Giovanni Antonio Pantera	34	NULL
Giovan Battista Moroni	Portrait of a Man with a Book	34	NULL
Giovanni Girolamo Savoldo	Transfiguration	34	NULL
Giulio Campi	Portrait of a Man	34	NULL
Giulio Campi	Portrait of Galeazzo Campi	34	NULL
Giulio Campi	Portrait of a Guitar-Player	34	NULL
Veronese	Holy Family with Saints Barbara and John	34	NULL
Veronese	The Martyrdom of Saint Justina	34	http://www.uffizi.firenze.it/Dipinti/verongiustiE34.html
Veronese	Saint Agatha Crowned by Angels	34	NULL
Veronese	Venus and Mercury Present to Jove their son Anteros	34	NULL
Veronese	Annunciation	34	NULL
Tintoretto	Portrait of a Man	34	NULL
Federico Barocci	Madonna del Popolo	35	NULL
Diego Velazquez and workshop (attr.)	Philip IV of Spain on Horseback	35	NULL
Rosso Fiorentino (or copy after)	Moses Defending Jethro's daughters	35	http://www.uffizi.firenze.it/Dipinti/rossoietroE35.html
Tiziano Vecellio	Portrait of Francesco Maria della Rovere	35	NULL
Tiziano Vecellio	Portrait of Eleonora Gonzaga della Rovere	35	NULL
Tiziano Vecellio	Flora	35	NULL
Tiziano Vecellio	Venus of Urbino	35	NULL
Sebastiano del Piombo	Portrait of a Woman	35	NULL
Parmigianino	Madonna with the Child and Angels, called "Madonna dal collo lungo"	35	NULL
Caravaggio	Head of Medusa	35	NULL
Caravaggio	The Sacrifice of Isaac	35	http://www.uffizi.firenze.it/Dipinti/caraisaccE16.html
Caravaggio	Bacchus	35	NULL
Raffaello Sanzio	Self-portrait	35	NULL
Raffaello Sanzio	Madonna of the Goldfinch	35	NULL
Bernardo Strozzi	Saint Catherine of Alexandria	38	NULL
Bernardo Strozzi	Saint Cecilia	38	NULL
Guido Reni	Madonna of the Snow	38	NULL
Giovan Antonio Fumiani	Stoning of Zacchary	38	NULL