elle
Member
Hello everyone,
I'm really not fit in MySQL! Really!
So please help me to get the right WHERE statement in my databasejoin element.
This is may setup:
I have a table named "tage", where stored a specific range of days, that is used just like an account.
The fields there are:
id | date_time | firma_tage | markt_tage | von | bis | tage | verbraucht | uebrig
In my new table named "terminplaner" I have the following elements (fields):
id | date_time | markt_planer | von_Planer | bis_Planer | firma_planer
The element firma_planer is a databasejoin element, with the following setup:
Options
I have tryed something like this:
But that does'nt work.
Can you help me please?
Best regards
Elle
I'm really not fit in MySQL! Really!
So please help me to get the right WHERE statement in my databasejoin element.
This is may setup:
I have a table named "tage", where stored a specific range of days, that is used just like an account.
The fields there are:
id | date_time | firma_tage | markt_tage | von | bis | tage | verbraucht | uebrig
In my new table named "terminplaner" I have the following elements (fields):
id | date_time | markt_planer | von_Planer | bis_Planer | firma_planer
The element firma_planer is a databasejoin element, with the following setup:
Options
- Plugin: databasejoin
- Render as: Checkbox
- Table: tage
- Value: id
- Label: firma_tage
- HERE is where i need youre help to do the following:
I have tryed something like this:
Code:
WHERE {thistable}.'markt_planer'
IN ( SELECT tage.firma_tage FROM tage
WHERE tage.markt_tage = {thistable}.'markt_planer'
AND tage.uebrig > 0)
Can you help me please?
Best regards
Elle