Tables in a query

[arvindn]

I need to know the names of tables from which a SQL select query pulls in data. For eg. if the query is

select * from bills inner join customers on bills.cust_id=customers.cust_id

i will pass the SQL string as an argument to the function and it should return a string "bills;customers" which i can then split to get the names of the tables.

Thanks in advance.

 

[llkhoutx]

Build the query in the QBE frame, then convert it to SQL, then cut and paste it in you code.

 

[arvindn]

Thank u. Someone else who is smarter out there ?

 

[arvindn]

Thanks a lot. That solves my purpose.