Combine two records in a single

What I miss?
X ;) (SCNR)

Which data field indicates that the records should be side by side? => Join T2.ThisField = T1.ThisField
 
In order to use a field, it must exist in the specified table. In your attempt, the subqueries simply take the fields from the InputT table, where the X field does not exist.
 

Users who are viewing this thread

Back
Top Bottom