https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/12243.aspxTue, 18 Jul 2006 16:59:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12243Matt Faus0https://www.infopathdev.com:443/forums/thread/12243.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12243Hm, I'm not sure that you will be able to do this with InfoPath's SQL abilities - they seem to be a bit limited. However, take this advice with a grain of salt as I am not even close to being a SQL expert, and can't honestly say that I know what an "implied Inner Join" is.<br /><br />What I would do is make two seperate data connections to both tables and then do the joining via XPath/XSL in the form. Whenever you need info from the other table, you can query it with XPath/XSL.https://www.infopathdev.com:443/forums/thread/12112.aspxMon, 17 Jul 2006 18:32:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12112dlgross0https://www.infopathdev.com:443/forums/thread/12112.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12112I need to be able to create a secondary data connection that contains a Left Outer Join between Table1 containing CityCodeIDs and Table2 containing City Names. Does anyone know where I can find the correct syntax for this? The Shape, Append, Relate structure created by IP does not seem to define the join type when creating the relationships so I am assuming the default is an implied Inner Join and I'm hoping there might be some way to override this behavior.