REGARDING ODBC STAGE

Saama · Post by **Saama** » Thu Feb 15, 2007 3:34 pm

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

urshit_1983 · Post by **urshit_1983** » Thu Feb 15, 2007 4:06 pm

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

narasimha · Post by **narasimha** » Thu Feb 15, 2007 4:24 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 15, 2007 5:28 pm

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.

DSguru2B · Post by **DSguru2B** » Thu Feb 15, 2007 9:11 pm

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