View Single Post
  #6 (permalink)  
Old September 30th, 2005, 05:48 AM
doggiebore doggiebore is offline
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can't see anything glaringly obvious. The actual condition seems to work ok when I tried it (ok, on a small table).

I'd try a simple query first just using the basic query tool add the two tables SM_PRODUCT & SM_PO and join them (does that need SM_PO_LN? then three tables)
Select a field to display from each table and then add the conditions. You should be able to see the SQL built to confirm the condition looks the same. Try running it, see if it works. Sometimes I've found the errors reported don't actually relate to the true cause of the problem.




Reply With Quote