InaPlex Forums

Inaport 7 Build 8130, SLX 7.2

My knowldge of SQL is lacking. When attempting to pull all fields from two tables, Inaport crashes. This is my selection string

SELECT  ACCOUNT.*, CONTACT.*  FROM  ACCOUNT, CONTACT WHERE ACCOUNT.ACCOUNTID = CONTACT.ACCOUNTID

Can someone please correct this?

Hi Doug

There is nothing particularly wrong with that SQL, though I would normally write it as:

SELECT a.*, c.* FROM account a INNER JOIN contact c ON a.accountid = c.accountid

I just tested your SQL against SalesLogix in Inaport and it was fine.

When you say you get a crash, what is happening? Perhaps generate a debug log and mail to support@inaplex.com

Regards

Admin

The Inner Join solved the problem for me. Thanks!

When I used the simpler Select statement, Inaport would either exit immediately without error or pull up SQL Server Enterprise Manager. Since it's now fixed, I won't bother to replicate the issue as it may be particular to our environment.

Hi Doug

The statements should have been equivalent. Perhaps something going on in the SQL optimazation in the server.

Regards

Admin