kmh496 wrote:
hi,
i am running a join query between the german_english table and the
user_todo_german_english tables, to figure out which words a user is
studying.
the key i am using is a combination of wordid + pos + posn (that is part
of speech == pos)
however, i am not able to correctly do the
2006-04-22 (토), 00:49 +0100, Philippe Poelvoorde 쓰시길:
> Hi,
>
> > mysql> select * from user_todo_german_english where wordid = '86851' and
> > posn = '1' and pos = 'm' AND mb_id='curious';
> > +-++--+--+-+
> > | mb_id | wordid | posn | pos | date_col
2006-04-22 (토), 08:43 +0900, kmh496 쓰시길:
> hi,
> i am running a join query between the german_english table and the
> user_todo_german_english tables, to figure out which words a user is
> studying.
> the key i am using is a combination of wordid + pos + posn (that is part
> of speech == pos)
> how
Hi,
> mysql> select * from user_todo_german_english where wordid = '86851' and
> posn = '1' and pos = 'm' AND mb_id='curious';
> +-++--+--+-+
> | mb_id | wordid | posn | pos | date_col|
> +-++--+--+-
hi,
i am running a join query between the german_english table and the
user_todo_german_english tables, to figure out which words a user is
studying.
the key i am using is a combination of wordid + pos + posn (that is part
of speech == pos)
however, i am not able to correctly do the join because of