??? ????? join ?? select ?? ??? ???? ???? ????. ??? ? ?????.
??? ???, 1?? BATCH ?? 99?? BRICK ? ????. ???, 1?? BRICK?? 1000??
SEQUENCE? ????.
BATCH Table
batch brick sequence pin amount
-----------------------------------------------------------------
68715 10001 10035 1234 $2.34
68715 10001 10047 2345 $3.23
68720 15001 15015 5432 $3.58
....
BRICK Table
batch brick sub_cust
-----------------------------------------------
68715 10001 wave1
68715 11001 wave1
68715 12001 wave2
68720 15001 wave3
....
?? ??? ???? batch, sequence, pin, amount from BATCH ???,
sub_cust from BRICK ???. ???
select BATCH.batch, BATCH.sequence, BATCH.pin, BATCH.amount,
BRICK.sub_cust
from BATCH, BRICK
where BATCH.sub_cust = 'wave1'
???, BATCH ???? ?? ?? ?? ?????.
?????.
?? DB LOVER!!!
|