Re: need help with relational tables/fields

2009-09-03 Thread Wolfgang Schaefer
AndrewJames schrieb: > Hey, > > i have a table called users which has my users in it, each have a uid > field. > I also have a stories table which has stories in it each with a sid field > for each story but also a uid field so i know which user the story > belongs > to. > > i want to write a que

Re: need help with relational tables/fields

2009-09-03 Thread Wolfgang Schaefer
AndrewJames schrieb: > Hey, > > i have a table called users which has my users in it, each have a uid > field. > I also have a stories table which has stories in it each with a sid field > for each story but also a uid field so i know which user the story > belongs > to. > > i want to write a quer

Re: need help with relational tables/fields

2009-09-03 Thread Wolfgang Schaefer
AndrewJames schrieb: > Hey, > > i have a table called users which has my users in it, each have a uid > field. > I also have a stories table which has stories in it each with a sid field > for each story but also a uid field so i know which user the story > belongs > to. > > i want to write a quer

need help with relational tables/fields

2009-09-03 Thread AndrewJames
Hey, i have a table called users which has my users in it, each have a uid field. I also have a stories table which has stories in it each with a sid field for each story but also a uid field so i know which user the story belongs to. i want to write a query that will display the story depending