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
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