I work in a large company in the automotive industry. We use the AS400 system corporately. I am just learning the query system. I have used a little of the iSeries and found that to be somewhat burdensome. My co-worker introduced me to the SQL language. What I am trying to do is using MS Access and a pass-through query to bring in more then one AS400 file to a single query. I have set up the passthrough query and developed the Select, Where, From statements. I have trying to linking and either my statements are wrong or it is my inexperience. Is it possible to bring more then one table in to a single query? The way I have been avoiding it is by developing single queries of the single tables and then allow MS Access to do the query of a query. Is there any info you can give me?
July 27, 2009 12:39 PM
July 28, 2009 8:33 PM