Radicore Forum: Transaction Patterns » Output2

Home » RADICORE development » Transaction Patterns » Output2 - SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Output2 - SQL [message #7335 is a reply to message #7334]

Thu, 22 August 2019 04:07

AJM
Messages: 2347
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.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Output2 - SQL By: htManager on Wed, 21 August 2019 17:11
		Re: Output2 - SQL By: AJM on Thu, 22 August 2019 04:07
		Re: Output2 - SQL By: htManager on Fri, 23 August 2019 05:24
		Re: Output2 - SQL By: AJM on Sat, 24 August 2019 04:27
		Re: Output2 - SQL By: htManager on Sun, 25 August 2019 13:30
		Re: Output2 - SQL By: AJM on Mon, 26 August 2019 04:42
		Re: Output2 - SQL By: htManager on Mon, 26 August 2019 09:36
		Re: Output2 - SQL By: AJM on Tue, 27 August 2019 04:46
		Re: Output2 - SQL By: htManager on Tue, 27 August 2019 09:13
		Re: Output2 - SQL By: AJM on Wed, 28 August 2019 05:15
		Re: Output2 - SQL By: htManager on Wed, 28 August 2019 06:56
		Re: Output2 - SQL By: AJM on Thu, 29 August 2019 03:49
		Re: Output2 - SQL By: htManager on Fri, 30 August 2019 10:00
		Re: Output2 - SQL By: AJM on Sat, 31 August 2019 04:41
		Re: Output2 - SQL By: htManager on Tue, 03 September 2019 06:15
		Re: Output2 - SQL By: AJM on Wed, 04 September 2019 04:41
		Re: Output2 - SQL By: htManager on Wed, 04 September 2019 06:25
		Re: Output2 - SQL By: AJM on Thu, 05 September 2019 04:14

Previous Topic:	add5 - Data Area
Next Topic:	Output2 - Options / 90° cell rotation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 18 16:38:08 EDT 2024

Total time taken to generate the page: 0.01113 seconds