hi
I use SQL select qmptc011.quid,qmptc011.item,qmptc015.* from qmptc011 left join qmptc015 on qmptc011.quid = qmptc015.quid

But Only display qmptc011 results,Can't dislay SQL query results on the Form.
Please help me.
Thanks

Hi,

Can you elaborate what you are trying to do here?

Is this query a part of Baan/LN session? Or is it an Easy SQL Query?

By looking at it's syntax, it looks more of an SQL Query used to run on the Database.

Table qmptc011 is Testing Combinations
There are item and it's Standard Test Produce in qmptc011.
as As shown below.
item Standard Test Produce code
A x01

Table qmptc015 Including the details of Standard Test Produce
as As shown below.

Standard Test Produce code ver aspect norm Lower limit Upper limit
x01 1 y01 4 3 5 6
x01 1 y02 4 3 5 6

I want to read item and Standard Test Produce code，then read all details According to the Standard Test Produce code.

as As shown below display on form.

item Standard Test Produce code ver aspect norm Lower limit Upper limit

A x01 1 y01 4 3 5 6
A x01 1 y02 4 3 5 6

Assuming this is for session .

Please check 'secondary tables' concept .

Hello,
you don't answer bhushan's question.

Is it a sessionscript
or
is it an easy SQL Query ?

Regards

Hi all,
I have provided detailed requirements in the attachment.
Please help me. thanks