add a tuple to the result of a query

[fatima]

Hello all,I want to add my own tuple to the final result of a SQL query but I don't know how I can do it.I have query like this:SELECT i.num, 1 AS lable, ‘book’ AS name, book.year AS attributesFROM i, bookWHERE ...and I want to add a tuple with these values to the result for using in some program:(num=null,lable=0,name='bib',attributes=null)I try to write a query like this : SELECT null AS num, 0 AS lable, ‘bib’ AS name, null AS attributesFROM ?and UNION that to SQL query but I must write some table name in 'from' clause.what should I do?

[Reg Edit]

Hello all,I want to add my own tuple to the final result of a SQL query but I don't know how I can do it.I have query like this:SELECT i.num, 1 AS lable, ‘book’ AS name, book.year AS attributesFROM i, bookWHERE ...and I want to add a tuple with these values to the result for using in some program:(num=null,lable=0,name='bib',attributes=null)I try to write a query like this : SELECT null AS num, 0 AS lable, ‘bib’ AS name, null AS attributesFROM ?and UNION that to SQL query but I must write some table name in 'from' clause.what should I do?

Just omit the FROM:

SELECT null AS num, 0 AS lable, 'bib' AS name, null AS attributesUNIONSELECT num, label, name, attributes FROM MyTable

[fatima]

Just omit the FROM:

SELECT null AS num, 0 AS lable, 'bib' AS name, null AS attributesUNIONSELECT num, label, name, attributes FROM MyTable

I thought the 'from' clause is not optional in SQL queries. thanks for your response, I will try it out.

[justsomeguy]

You only need FROM if you're selecting from a specific location. If you're just selecting a literal value there's nowhere to select it from.