Strange a SQL-statement only returns values using one table?
Example:
Code: Select all
Select
PUB."va-211".cdadmin,
PUB."va-211".cdorder,
PUB."va-211".cdprodukt,
PUB."bb-040"."omschr-35",
PUB."va-211".cdstatus,
PUB."va-211".aantbest,
PUB."va-211".aantgelev,
PUB."va-211".aanttefact,
PUB."va-211".aantgefact,
PUB."va-210"."datum-order",
PUB."va-210".cddeb,
PUB."va-210"."datum-lna",
PUB."va-210"."datum-lvoor"
From
PUB."va-211" Inner Join
PUB."bb-040"
On PUB."va-211".cdprodukt = PUB."bb-040".cdprodukt Inner Join
PUB."va-210"
On PUB."va-211".cdorder = PUB."va-210".cdorder And PUB."va-211".cdadmin =
PUB."va-210".cdadmin
Where
PUB."va-211".cdadmin = '01' And
PUB."va-211".cdstatus = 'O' And
PUB."va-210".cddeb = '{test(0)}'
Code: Select all
Select
PUB."va-210"."datum-order",
PUB."va-210".cddeb,
PUB."va-210"."datum-lna",
PUB."va-210"."datum-lvoor"
From
PUB."va-210"
Where
PUB."va-210".cddeb = '{test(0)'
So it seems that multiple table queries don't give a result??
Is that right? Or somebody has teh solution?