Yes, this is what i ended up doing and it works just fine. I wanted the
results in one record
and this does the job just fine.
I don't know enough about performance issues and whether this kind of
query
is inefficient compared to using a different database layout, but this is
not a
highly int
Thanks Matthew.
that works perfectly.
I totally forgot you can just select the table twice.
thanks for the quick response.
gf
"Matthew Smith" <[EMAIL PROTECTED]>
12/30/2002 11:34 AM
Please respond to msmith
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subje
Hello,
This is my first post to the list, so if I am asking in the wrong place, I
apologize.
I've got some trouble putting together a query with the following tables
Games: Teams:
gameid teamid
homeid name
awayid
datetime
i want to get all games within a certain time
Hello,
This is my first post to the list, so if I am asking in the wrong place, I
apologize.
I've got some trouble putting together a query with the following tables
Games: Teams:
gameid teamid
homeid name
awayid
datetime
i want to get all games within a certain time
