qry06
Books under $10 AND > 1 copy
The SQL AND, OR and NOT Operators
SELECT tblBook_Copies, tblBook_Title, tblBook_RetailPrice FROM tblBook WHERE tblBook_Copies > '1' AND tblBook_RetailPrice < '10' ORDER BY tblBook_Title ASC, tblBook_Copies DESC, tblBook_RetailPrice DESC
| Title |
|---|
| 1491: New Revelations of the Americas before Columbus |
| 33 Augenblicke des Glücks |
| A secular age |
| Alamein |
| American Language: An Inquiry into the Development of English in the United States |
| American Slavery, American Freedom: The Ordeal of Colonial Virginia |
| An American Bible: A History of the Good Book in the United States, 1777-1880 |
| Anatomy of Fascism |
| And a Hard Rain Fell: A GI's True Story of the War in Vietnam |
| Antichrist: Two Thousand Years of the Human Fascination with Evil |
| Apocalypses: Prophecies, Cults, and Millennial Beliefs through the Ages |
| Arab World Today |
| Arabia and the Arabs: From the Bronze Age to the Coming of Islam |
| Army at Dawn: The War in North Africa, 1942-1943 |
| At a Century's Ending: Reflections, 1982-1995 |
| Aus dem Leben eines Taugenichts |
| Auschwitz: A New History |
| Barbarians Speak: How the Conquered Peoples Shaped Roman Europe |
| Battle for God |
| Behind the Gates: Life, Security, and the Pursuit of Happiness in Fortress America |
| Beside Still Waters: Searching for Meaning in an Age of Doubt |
| Biedermann und die Brandstifter |
| Big Cotton: How a Humble Fiber Created Fortunes, Wrecked Civilizations, and Put America on the Map |
| Bomb: A Life |
| Breakout: The Chosin Reservoir Campaign, Korea 1950 |
| Britain and Germany in Europe, 1949-1990 |
| Brotherhood of Heroes: The Marines at Peleliu - 1944: The Bloodiest Battle of the Pacific War |
| Cannon fodder: an infantryman's life on the Western front, 1914-18 |
| Castles of Steel: Britain, Germany, and the Winning of the Great War at Sea |
| Central Europe: Enemies, Neighbors, Friends |
| Chaos: Making a New Science |
| Cheating Death: Combat Air Rescues in Vietnam and Laos |
| Christ's Churches Purely Reformed: A Social History of Calvinism |
| Collapse at Meuse-Argonne: The Failure of the Missouri-Kansas Division |
| Collapse: How Societies Choose to Fail or Succeed |
| Conclave: A Sometimes Secret and Occasionally Bloody History of Papal Elections |
| Constantine's Sword: The Church and the Jews |
| Dangerous Davies ... Bis über beide Ohren |
| Das Geheimnis der Haarnadel |
| Das siebte Kreuz |
| Delafield Commission and the American Military Profession |
| Der König verneigt sich und tötet |
| Der Sarg des Griechen |
| Descending from the Clouds: A Memoir of Combat in the 505 Parachute Infantry Regiment, 82d Airborne Division |
| Die Frau im Faß |
| Die Leiden des jungen Werthers |
| Dispatches from the Weimar Republic: Versailles and German Fascism |
| Downsize This! |
| Dust Bowl: The Southern Plains in the 1930s |
| Einstein's Clocks, Poincaré's Map: Empires of Time |
| Empires of the Atlantic world : Britain and Spain in America, 1492-1830 |
| Eye of the Lynx: Galileo, His Friends, and the Beginnings of Modern Natural History |
| Fall of the Roman Empire: A New History of Rome and the Barbarians |
| Food, Inc. - Mendel and Monsanto, The Promises and Perils of the Biotech Harvest |
| For the Survival of Democracy: Franklin Roosevelt and the World Crisis of the 1930s |
| Foundations of Moral Obligation |
| France on the Brink |
| France Under the Germans: Collaboration and Compromise |
| Freedom Riders: 1961 and the Struggle for Racial Justice |
| French Revolutions: Cycling the Tour de France |
| Galileo's Finger: The Ten Great Ideas of Science |
| Genes, Girls, and Gamow: After The Double Helix |
| Geometry of Design: Studies in Proportion and Composition |
| German Way of War: From the Thirty Years' War to the Third Reich |
| God ? A Biography |
| God Against the Gods: The History of the War Between Monotheism and Polytheism |
| God Delusion |
| Graphic Discovery: A Trout in the Milk and Other Visual Adventures |
| Great Civil War: A Military and Political History, 1861-1865 |
| Great War and Modern Memory |
| Great War: Perspectives on the First World War |
| Hell in the Holy Land : World War I in the Middle East |
| Hell is upon us : D-Day in the Pacific, June-August 1944 |
| History of Pakistan and its Origins |
| History of the Arab Peoples |
| History of the Jews in the Modern World |
| Hitler's Italian Allies: Royal Armed Forces, Fascist regime, and the war of 1940-43 |
| Holy Grail: Imagination and Belief |
| I Have Landed: The End of a Beginning in Natural History |
| Impressions and experiences of a French trooper, 1914-1915 |
| In der Hitze der Nacht |
| In the Company of Soldiers: A Chronicle of Combat |
| In the Legions of Napoleon: The Memoirs of a Polish Officer in Spain and Russia, 1808-1813 |
| In the Shadows of War: An American Pilot's Odyssey through Occupied France and the Camps of Nazi Germany |
| Inhuman Bondage: The Rise and Fall of Slavery in the New World |
| Intro to the New Testament |
| Inventing the Great Awakening |
| Islam's Black Slaves: The Other Black Diaspora |
| Joseph Smith: Rough Stone Rolling |
| Kleine Geschichte der Bundesrepublik Deutschland |
| Krieg, Nachkrieg |
| La Casa en Mango Street |
| Lee's Cavalrymen: A History of the Mounted Forces of the Army of Northern Virginia |
| Lee's Last Retreat: The Flight to Appomattox |
| Linked : the new science of networks |
| MacArthur's Victory: The War in New Guinea, 1943-1944 |
| Man Who Flew the Memphis Belle: Memoir of a WWII Bomber Pilot |
| Marianne in Chains: Daily Life in the Heart of France During the German Occupation |
| Mary Through the Centuries: Her Place in the History of Culture |
| Massacre at the Champ de Mars: Popular Dissent and Political Culture in the French Revolution |
| Military Half: An Account of Destruction in Quang Ngai and Quang Tin |
| Most Southern Place on Earth: The Mississippi Delta and the Roots of Regional Identity |
| Mörder gesucht |
| Name of War: King Philip's War and the Origins of American Identity |
| Nazi Conscience |
| Nazi Policy, Jewish Workers, German Killers |
| Neighbors & Strangers: The Fundamentals of Foreign Affairs |
| Never in Doubt: Remembering Iwo Jima |
| Nez Perce Summer, 1877: The U.S. Army and Nee-Me-Poo Crisis |
| Nixon's Shadow: The History of an Image |
| On War and Leadership: The Words of Combat Commanders from Frederick the Great to Norman Schwartzkopf |
| Operatives, Spies, and Saboteurs: The Unknown Story of the Men and Women of World War II's OSS |
| Origins of the Final Solution: The Evolution of Nazi Jewish Policy, September 1939-March 1942 |
| Our Own Devices: The Past and Future of Body Technology |
| Over Here: The First World War and American Society |
| Parades and Politics at Vichy; The French Officer Corps Under Marshal Pétain |
| Paul: A Study in Social and Religious History |
| People's Tycoon: Henry Ford and the American Century |
| Pilgrimage: An Image of Mediaeval Religion |
| Prophets: Who They Were. What They Are |
| Quest for Decisive Victory: From Stalemate to Blitzkrieg in Europe, 1899-1940 |
| Railroads and Rifles: Soldiers, Technology, and the Unification of Germany |
| Regulars: The American Army, 1898-1941 |
| Ripples of Battle: How Wars of the Past Still Determine How We Fight, How We Live, and How We Think |
| Road to Reality: A Complete Guide to the Laws of the Universe |
| Rome and the Barbarians: 100 B.C.-A.D. 400 |
| Rommel and His Art of War |
| Sacred Secrets: How Soviet Intelligence Operations Changed American History |
| Salt: A World History |
| Schlag nach bei Shakespeare |
| Seven Ages of Paris |
| Sherman's Horsemen: Union Cavalry Operations in the Atlanta Campaign |
| Silent Night: The Story of the World War I Christmas Truce |
| Slave Narratives |
| Socialism in Provence, 1871-1914: A Study in the Origins of the Modern French Left |
| Soldiers: Fighting Men's Lives 1901-2001 |
| Spanish Frontier in North America |
| Staat und Heer: ausgewählte historische Studien zum ancien régime, zur Französischen Revolution und zu den Befreiungskriegen |
| Suite française |
| Sundown Towns: A Hidden Dimension of American Racism |
| Tactics and the Experience of Battle in the Age of Napoleon |
| Tank Rider: Into the Reich with the Red Army |
| Teutonic Knights: A Military History |
| The culture of war |
| The end of chivalry: the last great cavalry battles, 1914-1918 |
| Their War for Korea: American, Asian, and European Combatants and Civilians, 1945-1953 |
| They fought for the Motherland : Russia's women soldiers in World War I and the Revolution |
| To the Last Man, Spring 1918 |
| Trickster Travels: A Sixteenth-century Muslim between Worlds |
| Trouble in Mind: Black Southerners in the Age of Jim Crow |
| User Illusion: Cutting Consciousness Down to Size |
| Visual Revelations: Graphical Tales of Fate and Deception from Napoleon Bonaparte to Ross Perot |
| War Law |
| War to End All Wars: The American Military Experience in World War I |
| Warfare and Society in Europe, 1792-1914 |
| Warriors: Portraits from the Battlefield |
| Wenn der Wetterhahn kräht |
| Who Were the Early Israelites, and Where Did They Come From? |
| With Our Backs to Berlin: The German Army in Retreat on the Eastern Front 1945 |
| Wolves in the City: The Death of French Algeria |