Re: SQL How To

new topic     » goto parent     » topic index » view thread      » older message » newer message 

Patrick Barnes wrote:
> 
> On 9/3/05, cklester <guest at rapideuphoria.com> wrote:
> > Should I do away with the sequence field and create a new table like so:
> >
> > prefs table (3 records):
> >    unique_id:1
> >    person:1
> >    fruit_pref:1
> >
> >    unique_id:2
> >    person:1
> >    fruit_pref:2
> >
> >    unique_id:3
> >    person:1
> >    fruit_pref:3
> 
> Yes, you should - that's a staple of relational databases.

Yeah, I figured as much... went ahead and did it... so... what's the SQL
query for gettin' that list of fruits?! :)

-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu