Hi,

I have SQL TABLE A
--------------------
RoomID
RoomName
OrderID


SQL TABLE B
------------
OrderItemID
RoomID
ModelName
GenericItem


How would I use the SHAPE command to join TABLE A and TABLE B together?

Thanks in advance..

niv