这样的三个表:(假设各有一条记录)TABLE1 (ID,KEY1,KEY2,VALUEx)
--------------------------------
001 01 01 helloTABLE2 (KEY1,VALUE1)
-----------------------
01 男的TABLE3 (KEY2,VALUE2)
----------------------
01 已婚我想得到这样的结果:
ID,KEY1,VALUE1,KEY2,VALUE2,VALUEx谁能帮帮我,这个select的语句怎么写啊,
我要写getall,和where id =?两种地好急啊
--------------------------------
001 01 01 helloTABLE2 (KEY1,VALUE1)
-----------------------
01 男的TABLE3 (KEY2,VALUE2)
----------------------
01 已婚我想得到这样的结果:
ID,KEY1,VALUE1,KEY2,VALUE2,VALUEx谁能帮帮我,这个select的语句怎么写啊,
我要写getall,和where id =?两种地好急啊
from table1 a,table b,table c
where a.key1=b.key1 and a.key2=c.key2
from table1 a,table2 b,table3 c
where a.key1=b.key1 and a.key2=c.key2