Ingo Foerster
asked on
SQL Join Question
Hi,
I have a table1:
/id/case_id/description/
1/101/My Test
2/102/Test 2
in table 2
/id2/case_id/state
1/101/2
2/101/1
3/101/2
I want now, from table 1 and 2 together
case_id/description/<last state/highest id of case_id from table 2>
like
case_id/description/id2/st ate
101/My Test/3/2
How to make the join for the result? And finally for all case_ids from table 1?
I have a table1:
/id/case_id/description/
1/101/My Test
2/102/Test 2
in table 2
/id2/case_id/state
1/101/2
2/101/1
3/101/2
I want now, from table 1 and 2 together
case_id/description/<last state/highest id of case_id from table 2>
like
case_id/description/id2/st
101/My Test/3/2
How to make the join for the result? And finally for all case_ids from table 1?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER