i use sql 2000 server. what query gets me T3 from T1 and T2?.
T1:
col1,col2,col3,col4,col5,col6:
T2:Code:Store1 district1 Inv1 PRICE1 item1 3 Store1 district1 Inv1 PRICE1 item2 3 Store1 district1 Inv1 PRICE1 item3 0 Store1 district1 Inv2 PRICE3 item1 3 Store1 district1 Inv2 PRICE3 item2 3 Store1 district1 Inv2 PRICE4 item3 0
col1,col2,col3:
T3:Code:A AVAIL item1 B AVAIL item3
Code:Store1 district1 Inv1 PRICE1 A AVAIL item1 3 Store1 district1 Inv1 PRICE1 B AVAIL item3 0 Store1 district1 Inv2 PRICE3 A AVAIL item1 3 Store1 district1 Inv2 PRICE4 B AVAIL item3 0




Reply With Quote