The MSI SQL Syntax is not a full SQL implementation. The documentation is complete. "WHERE" is what you're looking for I think.
-----Original Message----- From: Nic Barden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 09:54 To: WiX User Group Subject: [WiX-users] MSI SQL Join Syntax 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 [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
