BaseNow Forums

Home

Member List

Subscribe to all forums

» BaseNow Forums

» Bug Reports

» SQL Query builder problem

Welcome Guest ( Login or Register )

Active Topics |

Popular Topics

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

Posted 11/21/2005 1:38 AM

Forum Administrator

Group: Advanced Members
Active: 8/9/2024
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

Posted 11/21/2005 1:28 PM

Forum Member
Forum Newbie

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

..nice..

IP Logged

Showing page 1 of 1 - 3 messages found

« Next Oldest