JOINs in Jbase
- elix545
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 27
- Thank you received: 1
12 years 2 months ago #12450
by elix545
JOINs in Jbase was created by elix545
Hello Everyone,
How can translate to Base a query like:
How can translate to Base a query like:
select c.customer, a.account
form customer_table c , account_table a
where c.customer = a.account
The following user(s) said Thank You: thanhcon91
Please Log in or Create an account to join the conversation.
- elix545
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 27
- Thank you received: 1
12 years 2 months ago #12534
by elix545
Replied by elix545 on topic JOINs in Jbase
I found a manual jbase few days ago:
jBASE SQL Engine
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
12 years 2 months ago #12556
by jpb
Replied by jpb on topic JOINs in Jbase
So let us know if you managed to submit a SQLSELECT against T24 database.
(Found the trick to display fieldnames containing a dot?)
(Found the trick to display fieldnames containing a dot?)
Please Log in or Create an account to join the conversation.
- elix545
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 27
- Thank you received: 1
12 years 2 months ago - 12 years 2 months ago #12561
by elix545
Replied by elix545 on topic JOINs in Jbase
The dot in a field name is replaced but "." Ex:
for @ID is need to use the dict name of this field with:
LIST FBNK.CUSTOMER SHORT.NAME
SQLSELECT SHORT_NAME FROM FBNK.CUSTOMERfor @ID is need to use the dict name of this field with:
LISTDICT FBNK.CUSTOMER
Last edit: 12 years 2 months ago by elix545.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
12 years 2 months ago #12565
by jpb
Replied by jpb on topic JOINs in Jbase
So I assume you are using tafcR10 or above ;-)
Please Log in or Create an account to join the conversation.
- elix545
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 27
- Thank you received: 1
12 years 2 months ago #12566
by elix545
Replied by elix545 on topic JOINs in Jbase
When a customs table have a long name, how can use this table with jql?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
12 years 2 months ago #12567
by jpb
Replied by jpb on topic JOINs in Jbase
Create a VOC for the table with a different name, e.g.
COPY FROM VOC FBNK.LOCAL.TABLE.WITH.A.VERY.LONG.NAME.OR.SO,FBNK.LTWAVLNOS
and use this name in your query (don't change the contents of the VOC entry).
COPY FROM VOC FBNK.LOCAL.TABLE.WITH.A.VERY.LONG.NAME.OR.SO,FBNK.LTWAVLNOS
and use this name in your query (don't change the contents of the VOC entry).
Please Log in or Create an account to join the conversation.
Time to create page: 0.083 seconds