[ic] How can I convert an sql search to a page scan

[Jim Boyer <suppressed>]

Hi,

I need some help in converting a basic sql query into a page scan query.  I 
am running IC 4.9.5 with MySQL.  I would like to run a sql query that looks 
like this and returns to the results page like the scan function does.

select products.sku, product_category.category from products, 
product_category where
    product_category.category = "Family and Home";

I have tried several attempts with scan but nothing seems to work, here is 
an example

scan
  st=sql
  fi=products, product_category
  sf=product_category.category
  se=Family and Home
  rf=sku

Thanks for any help,

-------------------------------------------------------------

Jim Boyer
Systems Programmer
Information Dept
College of Agriculture and Home Economics
Washington State University 

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users