go.unc.edu/lbjones | Sample Queries: 01 | 03 | 04 | 06 | 07 | 09 | 11


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
1491: New Revelations of the Americas before Columbus
33 Augenblicke des Glücks
A secular age
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