🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.interbase.sql
1 messages
1 total messages Started by Nick Alexander Mon, 22 Sep 2008 11:08
Union query errors in Interbase
#195
Author: Nick Alexander
Date: Mon, 22 Sep 2008 11:08
39 lines
2551 bytes
I have 2 queries that I want to union.   I can run each query
separately and I get a result.   If I run both of them with a union, I
get the error message:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid command.
Data type unknown.

The full union query is:

SELECT JOB_COST_HEADER.PROJ_MASTER_REC_ID,
JOB_COST_ITEM.GLOB_PHASE_REC_ID, JOB_COST_ITEM.NAME,
Sum(JOB_COST_ITEM.QUANTITY) AS BudgetQuantity,
Sum(JOB_COST_ITEM.QUANTITY*JOB_COST_ITEM.COST_PRICE) AS BudgetCost,
Sum(0) AS PurchaseQuantity,
Sum(0) AS PurchaseCostPrice
FROM JOB_COST_ITEM INNER JOIN JOB_COST_HEADER ON
JOB_COST_ITEM.JOB_COST_HEADER_REC_ID = JOB_COST_HEADER.REC_ID
WHERE JOB_COST_HEADER.IS_CURRENT='Y' AND JOB_COST_HEADER.HEADER_TYPE=0
GROUP BY JOB_COST_HEADER.PROJ_MASTER_REC_ID,
JOB_COST_ITEM.GLOB_PHASE_REC_ID, JOB_COST_ITEM.NAME

union

SELECT PURCHASE_HEADER.PROJ_MASTER_REC_ID,
PURCHASE_ITEM.GLOB_PHASE_REC_ID, PURCHASE_ITEM.NAME,
Sum(0) AS BudgetQuantity,
Sum(0) AS BudgetCost,
Sum(PURCHASE_ITEM.QUANTITY) AS PurchaseQuantity,
Sum(PURCHASE_ITEM.QUANTITY*PURCHASE_ITEM.COST_PRICE) AS
PurchaseCostPrice
FROM PURCHASE_ITEM INNER JOIN PURCHASE_HEADER ON
PURCHASE_ITEM.PURCHASE_HEADER_REC_ID = PURCHASE_HEADER.REC_ID
GROUP BY PURCHASE_HEADER.PROJ_MASTER_REC_ID,
PURCHASE_ITEM.GLOB_PHASE_REC_ID, PURCHASE_ITEM.NAME

Can anyone shed any light?
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads