I have an ms sql query
select * from pass left join respuestas where pass.id=respuestas.id
The respuestas record points to pass and I can retrieve any field value from pass or respuestas from the generated recordset.
But the respuestas table has another value say idx that ponts to adifferent pass record. I need a value from the pass table.right now I am retrieveibg the value individually when required. it consumes a lot of resources. Is there a way ad add it to the recordset or somethng like
select * from pass left join respuestas where pass.id=respuestas.idx but I have to match the records. I am at a loss