```
select a,b,c, from transmission t where t.filnename ='ABC'  
select d,e,f, from transmission t where t.filnename ='ABC'

```

I want the results as two rows together into one resultset as result will go into DFF report. 

Output Should be: 

```
a,b,c  
d,e,f

```

I have tried UNION but it is giving me this error: 

> 
> Error converting data type varchar to bigint.
> 
> 
>