Is there a way to have a query show the table names as well as the column names in the result?

Example:

table 1:

clientNo
name
address

table 2:

clientNo
oderNo
orderAmount

Query:

select * from table1 inner join table2 on table1.clientNo=table2.clientNo

result should be

table1.clientNo  table1.name table1.address table2.clientNo table2.orderNo table2.orderAmount
1000 smith 41 street 1000 12345 1500

It is important that our clients can indentify the table out of which the data is extracted.

Kees,

<< Is there a way to have a query show the table names as well as the column
names in the result? >>

Do this in the TDBISAMQuery component:

In the AfterOpen event handler for the TDBISAMQuery component, loop through
the TFields and set their DisplayLabel value to the Origin property for the
TField.  That will make their titles show up as MyTable.MyColumn, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

This is amazing! We love DBIsam.
But you already knew that

Tx,
Kees

Another question about this topic:

the query goes likes this:

select * from A
inner join B as C on A.clientNo1=C.clientNo
inner join B as D on A.clientNo2=D.clientNo

When following the above mentioned tip the result looks like this:

A.clientNo1, A.clientNo2, B.name, B.name1

Is there any way to replace B with C and D in the result?

Kees,

<< Is there any way to replace B with C and D in the result? >>

That's a little tougher since C and D are only valid in the context of the
query, and I don't think we can change this without making the origins
completely unusable for other purposes.

--
Tim Young
Elevate Software
www.elevatesoft.com

I have solved it by creating temporary copies of the tables involved.

Tx - keep up the good work!