type filename size
___________________________
.txt ab.txt 12
.txt ab.txt 12
.txt cli.txt 14
.avi clie.avi 15
I have a table like this. i want to select the files where...
furobj:
item stock
alm2 5
alm3 0
order:
item quantity
alm3 2
when in table furobj an item's stock gets zero..... the item will be placed in order table.... how do i write the query in ms...
