-
Not specified
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.
================================================== ===============
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|