Join 2 queries

[semko]

I have two select statments:

FIRST:

select org.org_dij_organization_id org_id, org.kasa kasa
from org_dijelovi_kase org;

SECOND:

select 'PROIZVODI' from dual
union
select 'BARKODOVI' from dual
union
select 'STAVKE_CJENOVNIKA' from dual;

Both two selects give me results, which i want in one table. How to select parameters i want and put them in one table!?

THANK YOU !!!

[mwasif]

PROIZVODI, BARKODOVI, STAVKE_CJENOVNIKA

These are column names or you want to return these as it is?

Your first query returns 2 columns and 2nd query returns single column.
You can combine these 2 queries with UNION and to compensate the 2nd column you have to use NULL e.g.

SELECT org.org_dij_organization_id org_id, org.kasa kasa
FROM org_dijelovi_kase org
UNION
SELECT 'PROIZVODI', NULL FROM dual
UNION
SELECT 'BARKODOVI', NULL FROM dual
UNION
SELECT 'STAVKE_CJENOVNIKA', NULL FROM dual;

Make sure the data type must be same for the first column.

Is this is not what you are looking for, then please provide some sample data.