Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Transaction Patterns » Output2 - SQL
Re: Output2 - SQL [message #7335 is a reply to message #7334] Thu, 22 August 2019 04:07 Go to previous messageGo to previous message
AJM is currently offline  AJM
Messages: 2157
Registered: April 2006
Location: Surrey, UK
Senior Member
Your query is basically
SELECT ... FROM training_plan_anwesenheit LEFT JOIN training_plan_kopf ... 
WHERE training_plan_anwesenheit.tplan_anwesenheit_saison_id = 2018/2019'
If you replace the literal '2018/2019' with the column name training_plan_kopf.saison_id you are basically saying "use whatever value you find in column training_plan_kopf.saison_id", and as there is nothing in that query that limits that value to '2018/2019' it will use whatever values it finds.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: add5 - Data Area
Next Topic: Output2 - Options / 90° cell rotation
Goto Forum:
  


Current Time: Mon Nov 18 10:24:07 EST 2019

Total time taken to generate the page: 0.01176 seconds