| :: How do it? Use same table in query :: (2) | Post a New Message | Post a Reply |
 How do it? Use same table in query | Post a Reply |
since: Jan 17, 2008
from: EC
tabla1 (id , value , description)
1 , SO , windows 2000
1, version , 1.1
2 , SO , linux
2, version , 1.3
3 , SO , windows XP
3, version , 2.0.0
query .....
select a.value , b.value
from tabla1 a , tabla1 b
where a.value= 'SO'
and a.id = b.id
and b.value = 'version'
results ......
windows 2000 1.1
linux 1.3
windows XP 2.0.0
| Re: How do it? Use same table in query | Post a Reply |
from: Washington, DC
-------------------------
Ghost