Share
Report
20Hi, experts.
I want to integrate these three queries into one. I attempted to create a view for the second query, selecting values from table B without going through table A, and tried to integrate the values from the view along with the data from table C into a string variable for the parent query, but it didn't work well. I want to filter the data based on the condition /tableB.FieldY == tableA.Field1/ only for Field X.　I want to get other data without any conditions. How can I integrate them into one query?
while select
Field1,
Field2,
Field3,
from
transactionTemp
{
TableB transactionLine;
select minOf(FieldX)
from transactionLine
where transactionLine.FieldY == transactionTemp.Field1;
TableC tempSplit;
tempS.Field1 = transactionTemp.Field1;
tempS.Field2 = transactionTemp.Field2;
tempS.Field3 = transactionLine.FieldX;
tempS.insert();
}
while select
Field1,
Field2,
Field3,
from
tempS
order by
tempS.Field1,
tempS.Field2,
tempS.Field3
{
str field1 = tempS.Field1;
str field2 = tempS.Field2;
str field3 = tempS.Field3;
}
I want to integrate these three queries into one. I attempted to create a view for the second query, selecting values from table B without going through table A, and tried to integrate the values from the view along with the data from table C into a string variable for the parent query, but it didn't work well. I want to filter the data based on the condition /tableB.FieldY == tableA.Field1/ only for Field X.　I want to get other data without any conditions. How can I integrate them into one query?
while select
Field1,
Field2,
Field3,
from
transactionTemp
{
TableB transactionLine;
select minOf(FieldX)
from transactionLine
where transactionLine.FieldY == transactionTemp.Field1;
TableC tempSplit;
tempS.Field1 = transactionTemp.Field1;
tempS.Field2 = transactionTemp.Field2;
tempS.Field3 = transactionLine.FieldX;
tempS.insert();
}
while select
Field1,
Field2,
Field3,
from
tempS
order by
tempS.Field1,
tempS.Field2,
tempS.Field3
{
str field1 = tempS.Field1;
str field2 = tempS.Field2;
str field3 = tempS.Field3;
}
I have the same question (0)
All responses (
Answers (
