WX22 - Data Source Contents

Hi All

Could be a seriously dumb question but here goes.

I use HExecuteSQLQuery to collect data from a back end.

I am using a join that has the same field name in each of the two files being joined. How does WX differentiate between the two fields with the same name? Is there a way to see the fields in the data source?

Cheers
André

if your query is correctly written, then there is no ambiguity and your question is moot...

query should look something like this
Select File1.Field1 as Field1A, File2.Field1 as Field1B,....

both fields have the same name in the original files, but are internally known as Field1A and Field1B

If you use the query editor and look at the created sql code, you will see this in mode details.

Thank you - I hardly ever look at the query editor but will do so now - I forgot about that.