???Please could someone assist :  ???

I wish to link three tables with the INNER JOIN.

table 1 - orders primary file Key - OrderID

table 2 - order details - OrderID ProductID
from order details I get ProductID
table 3 - products ProductID

I am using the below suntax :

singleorderSQL=

select * FROM Orders INNER JOIN
(OrderDetails INNER JOIN Products ON
(Prodcts.ProductID = OrderDetails.ProductID) ON
(Orders.OrderID = OrderDetails.OrderID)
where OrderDetails.orderid="&orderid&" and not processed"

singleorder.open singleordersql,MM_SpaceTwo_STRING

When I run and attempt to access Products("DESCRIPTION") by referencing <%= Singleorder("DESCRIPTION") %> in my asp page I get the below error :


Microsoft VBScript runtime error '800a01a8'
Object required: ''

/spaceman/Spaceman_new/SpaceAdmin/view_new_orders.asp, line 253


All the information is correctly in the data base so suspect i have a syntax issue to deal with but cant for the life of me sort it.

Hope fully some fresh eyes will solve.

cheers
steve

hswes

You must write
select Orders.*, Products.* FROM Orders INNER JOIN
(OrderDetails INNER JOIN Products ON
(Prodcts.ProductID = OrderDetails.ProductID) ON
(Orders.OrderID = OrderDetails.OrderID)
where OrderDetails.orderid="&orderid&" and not processed"
Otherwise you get only the items from the Orders Table

Good luck

hswes