Join two select queries
I am trying to join two select queries. Here is my query.
(select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
When I execute this query throws me error
Context: Statement::Prepare( (select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id )
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
(
If I understand the error correctly, Firebird doesn't like '(' at the start of the query.
If so, how can I join two queries?
sql firebird
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
add a comment |
I am trying to join two select queries. Here is my query.
(select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
When I execute this query throws me error
Context: Statement::Prepare( (select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id )
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
(
If I understand the error correctly, Firebird doesn't like '(' at the start of the query.
If so, how can I join two queries?
sql firebird
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
add a comment |
I am trying to join two select queries. Here is my query.
(select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
When I execute this query throws me error
Context: Statement::Prepare( (select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id )
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
(
If I understand the error correctly, Firebird doesn't like '(' at the start of the query.
If so, how can I join two queries?
sql firebird
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
I am trying to join two select queries. Here is my query.
(select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
When I execute this query throws me error
Context: Statement::Prepare( (select 'stack' as id from RDB$DATABASE) t
inner join
(select 'stack' as id from RDB$DATABASE) q
on t.id=q.id )
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
(
If I understand the error correctly, Firebird doesn't like '(' at the start of the query.
If so, how can I join two queries?
sql firebird
sql firebird
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
edited Dec 31 '18 at 9:34
Mark Rotteveel
60.3k1477121
60.3k1477121
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
asked Dec 30 '18 at 23:37
MARKAND BhattMARKAND Bhatt
81542151
81542151
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The error "Token unknown - line 1, column 1 (" is returned because the presence of ( in that location is unexpected. Your current query only has two sub-queries it is trying to join, but it is missing the select and from clauses. This makes it a syntactically invalid statement. See SELECT in the Firebird 2.5 Language Reference for the full syntax.
A valid query would be
select *
from (select 'stack' as id from RDB$DATABASE) t
inner join (select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53982308%2fjoin-two-select-queries%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The error "Token unknown - line 1, column 1 (" is returned because the presence of ( in that location is unexpected. Your current query only has two sub-queries it is trying to join, but it is missing the select and from clauses. This makes it a syntactically invalid statement. See SELECT in the Firebird 2.5 Language Reference for the full syntax.
A valid query would be
select *
from (select 'stack' as id from RDB$DATABASE) t
inner join (select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
add a comment |
The error "Token unknown - line 1, column 1 (" is returned because the presence of ( in that location is unexpected. Your current query only has two sub-queries it is trying to join, but it is missing the select and from clauses. This makes it a syntactically invalid statement. See SELECT in the Firebird 2.5 Language Reference for the full syntax.
A valid query would be
select *
from (select 'stack' as id from RDB$DATABASE) t
inner join (select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
add a comment |
The error "Token unknown - line 1, column 1 (" is returned because the presence of ( in that location is unexpected. Your current query only has two sub-queries it is trying to join, but it is missing the select and from clauses. This makes it a syntactically invalid statement. See SELECT in the Firebird 2.5 Language Reference for the full syntax.
A valid query would be
select *
from (select 'stack' as id from RDB$DATABASE) t
inner join (select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
The error "Token unknown - line 1, column 1 (" is returned because the presence of ( in that location is unexpected. Your current query only has two sub-queries it is trying to join, but it is missing the select and from clauses. This makes it a syntactically invalid statement. See SELECT in the Firebird 2.5 Language Reference for the full syntax.
A valid query would be
select *
from (select 'stack' as id from RDB$DATABASE) t
inner join (select 'stack' as id from RDB$DATABASE) q
on t.id=q.id
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
edited Dec 31 '18 at 10:30
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
answered Dec 31 '18 at 9:34
Mark RotteveelMark Rotteveel
60.3k1477121
60.3k1477121
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53982308%2fjoin-two-select-queries%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
