Multi-table Join Using OTA but no Command Object
I don't understand how to do the equivalent of a simple SQL query against two or more tables using the OTA objects. I believe all the example code I've seen pulls data from just s single table (e.g., TEST, or BUG, or RUN etc).
For example, how do you do the equivalent of a
SELECT TEST.*, RUN.*
FROM TEST, RUN
WHERE TEST.TS_ID = RUN.TS_ID
The purpose of doing this might be, for example, to get the TS_NAME associated with RUN data.
If anyone has seen an example I'd appreciate your pointing me to it--I have not been able to find anything of the sort. THanks.
Re: Multi-table Join Using OTA but no Command Object
Read the OTA API guide that comes with QC or search the forum.