INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Lord Of The Rings','J. R. R. Tolkien',10.00,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Benjamin Franklin: An American Life','Walter Isaacson',21.00,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Seabiscuit: An American Legend','Laura Hillenbrand',9.57,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Beach House','James Patterson, Peter De Jonge',4.79,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Angels and Demons','Dan Brown',5.59,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Gettysburg','Stephen W. Sears',21.00,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'The Teeth of the Tiger','Tom Clancy',19.56,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') INSERT INTO BOOK (BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID) SELECT 'Netter''s Atlas of Human Anatomy','Frank H. Netter,John T. Hansen',48.26,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock') |