Re: How can I do this query ? (Join with a preselction)

2002-08-22 Thread DL Neil
Hi Andreas, > I'm just getting started with mysql so please bear with me. =8-} > I do a 3 table query like: > SELECT a.x, b.y, c.z > FROM a, b, c > WHERE a.b_fk = b.id AND a.c_fk = c.id; > That works so far. > In c can be rows which aren't active anymore. > There is a good_from and a good_until

How can I do this query ? (Join with a preselction)

2002-08-21 Thread Andreas
Hi I'm just getting started with mysql so please bear with me. =8-} I do a 3 table query like: SELECT a.x, b.y, c.z FROM a, b, c WHERE a.b_fk = b.id AND a.c_fk = c.id; That works so far. In c can be rows which aren't active anymore. There is a good_from and a good_until DATETIME field which