Join table error

Scriptcase 8 Discussion
#1

Hi! :smiley:

When I try to join two tables in a grid application by modifying the sql statement at the SQL section like this:
SELECT
supplier.id,
supplier.name,
supplier.address,
supplier.fax,
FROM
supplier,supplier_contact
WHERE
supplier.id=supplier_contact.supplier

I got an error like this:

How can I solve this problem?

Capture1.PNG

#2

[QUOTE=Brian;31703]Hi! :smiley:

When I try to join two tables in a grid application by modifying the sql statement at the SQL section like this:
SELECT
supplier.id,
supplier.name,
supplier.address,
supplier.fax,
FROM
supplier,supplier_contact
WHERE
supplier.id=supplier_contact.supplier

I got an error like this:

How can I solve this problem?[/QUOTE]

Try this:


SELECT[INDENT]supplier.id as id,
supplier.name as name,
supplier.address as address,
supplier.fax as fax
[/INDENT]
 FROM[INDENT]supplier,
supplier_contact
[/INDENT]
 WHERE[INDENT]supplier.id=supplier_contact.supplier[/INDENT]

Dave