Joins

[KenB]

The reports that I write require several tables. Sometimes as many as 5 or 6. Most reports have 3-4. The more involved reports requiring 4+ I convert to Foxpro, but this is a workaround, rather then a solution. I have been using R&R since v1.2 and am well adapt in writing these. I just have no background in programming in sql. I am pulling the data from Visual Accountmate. We have MS SQL.

[KenB]

Maybe my lack of knowledge of sql is finally catching up, but I cannot make a join work unless it is the default "skip". I am trying to do a report that shows certain inventory items and relate them to sales orders. If no slasorder exists, it skips the inventory record. I want the inventory record to show regardless of whether or not a slaes order exists.____A little direction would be greatly appreciated. I am using Infinity with the latest build.

[kfleming]

Does the report have more than one joined table?__What database platform are you using?____Kathleen__R&R Support

[KenB]

Not sure if you received my response.____Using MS SQL. Most reports require 3 or 4 tables, some as much as 6. I have no problem when I convert tables to Foxpro files. Software is Visual Accountmate.