Hi all,

i have two table :

looks like


table 1 data

id operation
234 sdfggg:gggh
245 fggh:ghh


table2 data


id operation
234 abcdefr:hhj
234 fgghghhhhh
234 3456666666
245 hfkgjgkgkkk
245 545666666

as you can see that both table contains two filels id and operation.

now i want the output looks like

id operation(from table1) operation(from table2)
234 sdfggg:gggh abcdefr:hhj
fgghghhhhh
3456666666

245 fggh:ghh hfkgjgkgkkk
545666666

here id 234 can contains multiple operation in table 2 so i want to print all multiple operation corresonds to single operation/id without print them again(single operation/id)

i means i dnt want the print like:

id operation(from table1) operation(from table2)
234 sdfggg:gggh abcdefr:hhj
234 sdfggg:gggh fgghghhhhh
234 sdfggg:gggh 3456666666


any helps to write this query...