DSXchange

Hi Gurus,
Is it possible to select only one table name but in the column section we define the columns from multiple tables.When i tried iam getting error-repository interface. Is it possible, one of my friend is saying that its possible.

Plz Gurus help me to analyze

cheers

Dont understand why you want to do that. What is the database , If you are using ODBC as native driver ?

How can you choose a single table and select columns from many tables?
You need to give reference to all the tables from which you are selecting from.

Ask your friend HOW it's possible, since your friend appears to have - or at least to claim - some expertise. Posting the answer back here will help anyone who encounters this question in future.

It is possible if you want to join two tables and specify the second table's name in the sql.