Normalising sql

Soldato
Joined
24 Nov 2002
Posts
16,378
Location
38.744281°N 104.846806°W
I have a simple mysql table, for example:

Code:
Book              Genre
Veg is cool      1, 3, 4

And another table,

Code:
Genre              Def
1                     Factual
2                     Fiction
3                     Recipe book
4                     New
5                     Used

I naturally want to normalise this. Is there an intrinsic way to do this with sql (join?)? As I'm using php queries to do it at the moment.
 
Back
Top Bottom