Search:

Ahh, I understand the logic now, thanks for your help!

Table 1 Table 2
1 1 a
2 1 b
3 1 c

I want to concatenate a b c onto a single details line for the value in Table 1.

This is as...

Yeah, I'd got as far as the extraction and creating a loop for the link but couldn't figure out to make the join.

Thanks for having a look.

hiya,

crystal xi, oracle db 10g.

Thanks

Hi, I'm having trouble extracting some data.

Table 1
field 1 field 2 field 3
1 a Fred
2 b John
3 c Paul

Table 2
Field 1 field 2