BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Login Register Member List
  » BaseNow Forums   » Bug Reports   » SQL Query builder problem  

Welcome Guest ( Login or Register )


SQL Query builder problem
Author
Message
Posted 11/16/2005 5:42 AM
Forum Member
Forum Newbie

Group: Forum Members
Active: 11/21/2005
Posts: 2

Hi,

I can't execute this SQL

SELECT
 BRANDS.*,
 CATEGORIES.*,
 PRODUCTS.*
FROM
 (PRODUCTS
 LEFT JOIN BRANDS ON BRANDS.BRA_ID = PRODUCTS.PRO_BRAND)
 INNER JOIN CATEGORIES ON CATEGORIES.CAT_ID = PRODUCTS.PRO_CATEGORY

When I try to execute query I get this alert: "Microsoft DataGrid Control: Cannot initialize data bindings"

Please, what's the problem?
Thanks

IP Logged
This member is offline.
Posted 11/21/2005 1:38 AM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64
Unfortunately, such query is not supported in the Query Builder tool. Try to specify the exact names of the columns after the SELECT keyword.
IP Logged
This member is offline.
Posted 11/21/2005 1:28 PM
Forum Member
Forum Newbie

Group: Forum Members
Active: 11/21/2005
Posts: 2

..nice..

IP Logged
This member is offline.
Showing page 1 of 1 - 3 messages found
« Next Oldest

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.