Need a SQL statement focus on combination of tables but entries always with uinque ID
- by Registered User KC
Hi All,
I need SQL code to solve the tables combination problem, described on below:
Table old data:
name version status lastupdate ID
A 0.1 on 6/8/2010 1
B 0.1 on 6/8/2010 2
C 0.1 on 6/8/2010 3
D 0.1 on …