|
|
| ◄◄ First ◄ Previous | All illustrations: Item 472 of 868 [Back to Search/Browse Results] | Next ► Last►► |
![]()
© 2007 Dr Julia Thomas, Dr Tim Killick, Dr Anthony Mandal, Professor David Skilton
SELECT * FROM HostText INNER JOIN Illustration ON HostText.HostID = Illustration.HostID WHERE DMVICode='OF003'
SELECT DMVICode, Facet, Cat1, Cat2, Cat3 FROM Classification INNER JOIN IllusCat ON Classification.CatID = IllusCat.CatID GROUP BY DMVICode, Facet, Cat1, Cat2, Cat3 HAVING DMVICode='OF003' ORDER BY Min(DisplayOrder);