SQL and IN

Hi,

is this possible:

Let's say I have a Table which has the column Id. This table should have 3 rows, with Id 1,2,3.

When i query for: select * from Table where Id IN (1,2,4) i will get 2 rows:

1, foo1, bar1
2, foo2, bar2

But i need 3 rows, Id 1 and 2, with the data of these rows and 4 with all column values set to null besides Id which shall be 4.

1, foo1, bar1
2, foo2, bar2
4, null, null