Please find the structure of table1 and table 2. I need the results as displayed
in Table 3. This is very similar to a cross-tab Query. However, the number
of records in table 1 and 2 are arbitrary.

Any body can help me please? I'm looking for the SQL statement to achieve this


Property (Table 1)
__________________________________________
lng_id field field prompt
__________________________________________
1 segment pipeline segment
2 length Total length
3 size Size
4 reading UT reading
etc.
================================================== ===============

Inspection (Table 2)
__________________________________________
Record ID lng_prop_id Value
__________________________________________
1 1 Seg1
1 2 3.00
1 3 3.40
1 4 5.99
2 1 Seg2
2 2 2.30
2 3 4.30
2 4 1.20

etc.

================================================== ===============
Result (Table 3)
__________________________________________
segment length size reading
__________________________________________
Seg1 3 3.4 5.99
Seg2 2.3 4.3 1.2

etc.
================================================== ===============