mysql> show create table recipe\G
*************************** 1. row ***************************
       Table: recipe
Create Table: CREATE TABLE `recipe` (
  `RecipeId` int(11) NOT NULL,
  `Source` varchar(60) DEFAULT NULL,
  `Comments` varchar(255) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `numServings` int(11) DEFAULT NULL,
  PRIMARY KEY (`RecipeId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> SELECT quantity, name FROM ingredientList INNER JOIN ingredientList.ingre
dient ON ingredientList.ingredientId = ingredient.ingredientId;
ERROR 1146 (42S02): Table 'ingredientlist.ingredient' doesn't exist