So I've put together a custom query that looks like the following:
specialOrderItems = Application.DatabaseBlocks.SelectRecords(
selectClause:"category.catid AS category_catid, category.category AS category_category, items.itemid AS items_itemid, items.catid AS items_catid, items.item AS items_item, ratings.itemid AS ratings_itemid, ratings.use AS ratings_use, ratings.custService AS ratings_custService, ratings.roi AS ratings_roi, ratings.prhr AS ratings_prhr",
fromClause:"category, items, ratings",
whereClause:"category.catid=items.catid AND items.itemid=ratings.itemid"
);
Everything up until the whereClause seems to work fine and I've tried using both the aliases created in the selectClause and the standard table.column layout as you see above. But, to no avail. Any ideas as to what I'm doing wrong. Any help would be greatly appreciated.
Thanks,
--Anne
Confidentiality Notice: This E-Mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the E-Mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or reliance upon the contents of this E-Mail is strictly prohibited. If you have received this E-Mail transmission in error, please reply to the sender, so arrangements can be made for proper delivery, and then delete the message from your system. Thank you.
********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
