Crash Courese needed"!!

[Chance1234]

ok im workign with sybase for the first time, i have on my machine somehting called sybase central and sybase advantage,

now worked out sybase advantage i can type in some sql ! and execute it and sybase central lists all the tables and stuff in the database im workign in ! 300 hours later ;-)

im using powerpoint and bringing in data from the database, no problem so far as till now ive been using euarys straight from the tables in the database but....

I need to use a union query and run a query of that union query and access the results in powerpoint.

bascily what i have is a group of tables all with the common column id Analysis ID, what i want to do is create a query so i know which analysis id appears in which table, now my query looks something like this

SELECT DISTINCT analysis_id, "Initial 2 Risk analysis" AS TblToAdd FROM ATReportRisk
UNION SELECT DISTINCT analysis_id, "Initial Risk booking Report" AS TblToAdd FROM ATReportRiskBmk
UNION SELECT DISTINCT analysis_id, "Risk Return sector" AS TblToAdd FROM ATReportRiskReturn

i execute that query in sql advantage and it works, i cna laso do the ADO in powerpoint and it works but,,,,, what i want to do then is fromt hat query just select one id and tell me what tables are there so i can populate a list box.

now if i was using access 97 i would save the above query and access the query from powerpoint but i dont know how to do this in sybase


Chance,