Displaying 1 result from an estimated 1 matches for "widgetstyl".
Did you mean:
widgetstyle
2005 Jun 02
1
Populating Data on a Foreign Table
the scenario...
three tables, thusly:
widgets
-------
id
widget_color_id
widget_style_id
widget_colors
-------------
id
color
widget_style
------------
id
style
the data:
widgets
-------
1 2 1
2 1 3
3 3 2
widget_colors
-------------
1 blue
2 red
3 green
widget_styles
-------------
1 smooth
2 round
3 broken
so, putting the associations together, we have in widgets:
1 red smooth
2 blue