See the link to the picture. Maybe that will make more sense. Those two
tables have enough information to make that one query. I can't alter the two
tables. That is all the info I have. That is just the way our POS database
records data and nothing but an act of god, a CTO, and a few million dollars
is going to change that.

I want to be able to query those two tables and get the response in the
bottom of the image. There is enough data in those two tables to build that,
but I just don't know how to do it.

http://img209.imageshack.us/img209/3760/qrytroubles.png

"KARL DEWEY" wrote:

You need TransDate so as to see 'what was when'.

tblInstruction to have these --
InstructionID
Instruction
Tool

Either add InstructionID to Step or Transaction.

--
Build a little, test a little.


"JonB" wrote:

Actually, to clarify, I want to be able to query and get:

widget,batch,instruction,tool
A,66,1,WidgetStomper
A,66,2,WidgetPresser
A,99,3,WidgetHeater
A,99,4,WidgetFreezer

I really want to be able to see what tool each widget has gone through, but
we only track what goes into a tool by batch.