Need a great coder to spot my error - help
This problem is very similar to mine -- I'm sure it's something wrong with my code.
Here's a screenshot of what I have. I've pasted the code below in case you can't read the image.
Note that my table is "visitors" and not "users."
SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailOrderID
WHERE orderdetails.DetailOrderID = WADAOrderID AND orders.OrderVisitorID = paramUserID
Also note that in the wizard when I create the param I already have an exisiting param. Are there supposed to be 2 param?
Thanks.