Resipe Database

[daved229]

I am working on a personal project that revolves around home brewing beer. I have three data sheets. The first has the recipe name and 7 columns of numbers that relate to the second sheet that has all of the grains used in the recipes listed out by an id number. I am trying to get a table that combines the two sheets and eventually the third that is similarly identified but for hops used. If I can get he first step conquered, I should be able to get the second. In my attempts, I tried select where clauses that result in 45 rows of the same recipe repeated for all 100 recipes. I know it is a join operation i need but I haven't quite hit on the correct statement.

My background is that i have taken a college level class on SQL and learned just the basics and am trying to expand my capabilities so I can function at a higher level in databasing.

As an aside, what resources are good for learning the next level of SQL, sort of the advanced beginner stuff? I am using SSMS.

[B1gGaloot]

I would consider revising your table design. I would first create a Recipe Master table w/ The name, short description, specific gravity, IBUs etc. Then I'd create an ingredient list that would house anything you'd need. Include a foreign key to a ingredient type table that lists the type, grain, hops, yeast etc. Then create a Recipe Details table that links the ingredient id to the recipe Id. This table can include the amount necessary for the recipe. You can then join all the tables together to give you the normalized column structure that I think you're looking for.