Hi, Does anyone know the correct syntax for joining 2 tables in MSI SQL? There isn't a lot of help from the formal documentation at http://msdn.microsoft.com/en-us/library/aa372021(VS.85).aspx I am trying to join the SqlScript and Binary tables to get a list of binary files that are actually SQL Scripts. I have the SQL "SELECT `Name`, `Data` FROM `Binary` INNER JOIN `SqlScript` ON `Binary`.`Name` = `SqlScript`.`ScriptBinary`". However this throws the error through DTF: "SQL query syntax invalid or unsupported. Database: xxxxTest.msi. Invalid or missing query string: SELECT `Name`, `Data` FROM `Binary` INNER JOIN `SqlScript` ON `Binary`.`Name` = `SqlScript`.`ScriptBinary`. Any references to blogs/documentation on this topic also would be appreciated if anyone has any. Thanks! _________________________________________________________________
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
