We have a table which consist of following two fields

Table name: Tab1
Field1 Field3

1 OK1

1 OK2

2 OK3

2 OK4

3 OK5

For every Field1 value, We need to know the values of Field3 in a single row.

Output has to be like this



Field1 Field3(1) Field3(2)

1 OK1 OK2

2 OK3 OK4

3 OK5 NULL


Thanks In Advance

Paddy