- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Join problem with ImageSql
Operating System - HP-UX
1748234
Members
3333
Online
108759
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2002 05:24 AM
07-22-2002 05:24 AM
Join problem with ImageSql
From some days I've problem with sql to ImageSql. Easy question (like agregate function, group by, select)are ok,
but with Join :
/Sql
select consignment.* , transport.*
from
consignment LEFT JOIN transport
ON consignment.transport = transport.transport
WHERE
(consignment.transport LIKE 'ty%') OR (consignment.transport LIKE '____ty%')
if I aplly this I've BDE error:
Bde error = 13059
" [MiniSoft] [3kodbc.dll] Syntax error in
table list."
/Sql
MS Axcess doing this sql with no problems to
/Sql
SELECT DBCONS_CONSIGNMENT.COLLECT_DATE, DBCONS_CONSIGNMENT.DELIVER_DATE, DBCONS_TRANSPORT.TRAFFIC, DBCONS_TRANSPORT.TRANSPORT, DBCONS_CONSIGNMENT.CONSIGNMENT, DBCONS_CONSIGNMENT.TRAFFIC_FROM, DBCONS_CONSIGNMENT.TRAFFIC_TO, DBCONS_CONSIGNMENT.DEPARTMENT, DBCONS_CONSIGNMENT.STATUSTEXT, DBCONS_CONSIGNMENT.[NO], DBCONS_CONSIGNMENT.CLL, DBCONS_CONSIGNMENT.G_WEIGHT, DBCONS_CONSIGNMENT.N_WEIGHT, DBCONS_INVOICING.AMOUNT, DBCONS_CONSIGNMENT.SHIP_NO, DBCONS_CONSIGNMENT.SHIP_ADDRESS_1, DBCONS_CONSIGNMENT.SHIP_ADDRESS_2, DBCONS_CONSIGNMENT.DELV_NO, DBCONS_CONSIGNMENT.DELV_ADDRESS_1, DBCONS_CONSIGNMENT.DELV_ADDRESS_2
FROM DBCONS_INVOICING RIGHT JOIN (DBCONS_CONSIGNMENT LEFT JOIN DBCONS_TRANSPORT ON DBCONS_CONSIGNMENT.TRANSPORT = DBCONS_TRANSPORT.TRANSPORT) ON DBCONS_INVOICING.CONSIGNMENT = DBCONS_CONSIGNMENT.CONSIGNMENT
GROUP BY DBCONS_CONSIGNMENT.COLLECT_DATE, DBCONS_CONSIGNMENT.DELIVER_DATE, DBCONS_TRANSPORT.TRAFFIC, DBCONS_TRANSPORT.TRANSPORT, DBCONS_CONSIGNMENT.CONSIGNMENT, DBCONS_CONSIGNMENT.TRAFFIC_FROM, DBCONS_CONSIGNMENT.TRAFFIC_TO, DBCONS_CONSIGNMENT.DEPARTMENT, DBCONS_CONSIGNMENT.STATUSTEXT, DBCONS_CONSIGNMENT.[NO], DBCONS_CONSIGNMENT.CLL, DBCONS_CONSIGNMENT.G_WEIGHT, DBCONS_CONSIGNMENT.N_WEIGHT, DBCONS_INVOICING.AMOUNT, DBCONS_CONSIGNMENT.SHIP_NO, DBCONS_CONSIGNMENT.SHIP_ADDRESS_1, DBCONS_CONSIGNMENT.SHIP_ADDRESS_2, DBCONS_CONSIGNMENT.DELV_NO, DBCONS_CONSIGNMENT.DELV_ADDRESS_1, DBCONS_CONSIGNMENT.DELV_ADDRESS_2
HAVING (((DBCONS_CONSIGNMENT.COLLECT_DATE)=20630) AND ((DBCONS_CONSIGNMENT.DEPARTMENT)="PST24"))
ORDER BY DBCONS_CONSIGNMENT.COLLECT_DATE, DBCONS_TRANSPORT.TRANSPORT;
/Sql
I've Delphi 6 programmer, I connect
with DAtaBAse by ODBC HP 3000 Data Axcess Driver.
Operating system with DB: MPE/iX C.70.01
DB ver allbase/sql: A.G3.22
Operating system from I doing sql:Win98
I connect with DB by ODBC HP 3000 Data Axcess Driver.
My ODBC Driver settings
lock retries = 1
Century Split year = 0
Disable HP3000 transactions = not checked
Enable item-level locking = checked
Use standard sql join processing = checked
Auto-Commit ON is the default = checked
all warrnings are trated as errors = not checked
Database Open mode = 5. read concurrent modify
So what it's wrong in my SELECT ?
but with Join :
/Sql
select consignment.* , transport.*
from
consignment LEFT JOIN transport
ON consignment.transport = transport.transport
WHERE
(consignment.transport LIKE 'ty%') OR (consignment.transport LIKE '____ty%')
if I aplly this I've BDE error:
Bde error = 13059
" [MiniSoft] [3kodbc.dll] Syntax error in
table list."
/Sql
MS Axcess doing this sql with no problems to
/Sql
SELECT DBCONS_CONSIGNMENT.COLLECT_DATE, DBCONS_CONSIGNMENT.DELIVER_DATE, DBCONS_TRANSPORT.TRAFFIC, DBCONS_TRANSPORT.TRANSPORT, DBCONS_CONSIGNMENT.CONSIGNMENT, DBCONS_CONSIGNMENT.TRAFFIC_FROM, DBCONS_CONSIGNMENT.TRAFFIC_TO, DBCONS_CONSIGNMENT.DEPARTMENT, DBCONS_CONSIGNMENT.STATUSTEXT, DBCONS_CONSIGNMENT.[NO], DBCONS_CONSIGNMENT.CLL, DBCONS_CONSIGNMENT.G_WEIGHT, DBCONS_CONSIGNMENT.N_WEIGHT, DBCONS_INVOICING.AMOUNT, DBCONS_CONSIGNMENT.SHIP_NO, DBCONS_CONSIGNMENT.SHIP_ADDRESS_1, DBCONS_CONSIGNMENT.SHIP_ADDRESS_2, DBCONS_CONSIGNMENT.DELV_NO, DBCONS_CONSIGNMENT.DELV_ADDRESS_1, DBCONS_CONSIGNMENT.DELV_ADDRESS_2
FROM DBCONS_INVOICING RIGHT JOIN (DBCONS_CONSIGNMENT LEFT JOIN DBCONS_TRANSPORT ON DBCONS_CONSIGNMENT.TRANSPORT = DBCONS_TRANSPORT.TRANSPORT) ON DBCONS_INVOICING.CONSIGNMENT = DBCONS_CONSIGNMENT.CONSIGNMENT
GROUP BY DBCONS_CONSIGNMENT.COLLECT_DATE, DBCONS_CONSIGNMENT.DELIVER_DATE, DBCONS_TRANSPORT.TRAFFIC, DBCONS_TRANSPORT.TRANSPORT, DBCONS_CONSIGNMENT.CONSIGNMENT, DBCONS_CONSIGNMENT.TRAFFIC_FROM, DBCONS_CONSIGNMENT.TRAFFIC_TO, DBCONS_CONSIGNMENT.DEPARTMENT, DBCONS_CONSIGNMENT.STATUSTEXT, DBCONS_CONSIGNMENT.[NO], DBCONS_CONSIGNMENT.CLL, DBCONS_CONSIGNMENT.G_WEIGHT, DBCONS_CONSIGNMENT.N_WEIGHT, DBCONS_INVOICING.AMOUNT, DBCONS_CONSIGNMENT.SHIP_NO, DBCONS_CONSIGNMENT.SHIP_ADDRESS_1, DBCONS_CONSIGNMENT.SHIP_ADDRESS_2, DBCONS_CONSIGNMENT.DELV_NO, DBCONS_CONSIGNMENT.DELV_ADDRESS_1, DBCONS_CONSIGNMENT.DELV_ADDRESS_2
HAVING (((DBCONS_CONSIGNMENT.COLLECT_DATE)=20630) AND ((DBCONS_CONSIGNMENT.DEPARTMENT)="PST24"))
ORDER BY DBCONS_CONSIGNMENT.COLLECT_DATE, DBCONS_TRANSPORT.TRANSPORT;
/Sql
I've Delphi 6 programmer, I connect
with DAtaBAse by ODBC HP 3000 Data Axcess Driver.
Operating system with DB: MPE/iX C.70.01
DB ver allbase/sql: A.G3.22
Operating system from I doing sql:Win98
I connect with DB by ODBC HP 3000 Data Axcess Driver.
My ODBC Driver settings
lock retries = 1
Century Split year = 0
Disable HP3000 transactions = not checked
Enable item-level locking = checked
Use standard sql join processing = checked
Auto-Commit ON is the default = checked
all warrnings are trated as errors = not checked
Database Open mode = 5. read concurrent modify
So what it's wrong in my SELECT ?
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2002 11:44 PM
07-22-2002 11:44 PM
Re: Join problem with ImageSql
Hi Pawel
I do not know exactly the syntax of imagesql but assuming that it is not very different from pure sql i would say the problem is the usage of LEFT JOIN
If you just copy sql syntax from MSACCESS this will not run with pure sql because of LEFT JOIN or RIGHT JOIN is not known by sql
try instead :
select table1.*,table2.*
from table1,table2
where table1.field1 = table2.field1 (+)
<< this will be a right join in MSACCESS (if i'm not totally wrong)>>
A left join you get by :
where table1.field1 (+) = table2.field1
Hope this is a help for you
I do not know exactly the syntax of imagesql but assuming that it is not very different from pure sql i would say the problem is the usage of LEFT JOIN
If you just copy sql syntax from MSACCESS this will not run with pure sql because of LEFT JOIN or RIGHT JOIN is not known by sql
try instead :
select table1.*,table2.*
from table1,table2
where table1.field1 = table2.field1 (+)
<< this will be a right join in MSACCESS (if i'm not totally wrong)>>
A left join you get by :
where table1.field1 (+) = table2.field1
Hope this is a help for you
keep it simple
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP