add a row to the fetch array by query

[ted_chou12]

Hi, I am wishing to add a row just by query such that it returns the queried row as if it was in the table:

suppose the db has two rows:

[id][name]

1test1

2test2

However, i want to added another entry:

id 3, name test3 while returning the result so it appears like

[id][name]

1test1

2test2

3test3

the row id3 is not actually in the db. Can you actually put something in the query so it appears like its fetching another row:

SELECT * FROM album ADD (id='3' name='test3')

Something like this? (I have checked join and leftjoin, i think those are joining two physical tables together, not actually adding a row.)

Thanks,

Ted

[fenway]

Use UNION.