|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
From: Brian Dunning (brian
briandunning.com)
Date: Fri Sep 05 2008 - 15:28:31 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
How do I query "How many calories did Brian eat on 2009-09-04"?
Table:People
+-----------+-------+
+ Person_ID + Name |
+-----------+-------+
| 5 | Brian |
+-----------+-------+
Table:Meals
+---------+-----------+-----------+------------+
| Meal_ID | Person_ID | Meal_Name | Date |
+---------+-----------+-----------+------------+
| 3 | 5 | Breakfast | 2009-09-04 |
| 4 | 5 | Lunch | 2009-09-04 |
+---------+-----------+-----------+------------+
Table:Meal_Items
+-------------+---------+-----------+----------+
| MealItem_ID | Meal_ID | Item_Name | Calories |
+-------------+---------+-----------+----------+
| 16 | 3 | Banana | 100 |
| 17 | 3 | Milk | 150 |
| 18 | 4 | Cookie | 200 |
+-------------+---------+-----------+----------+
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]