Inserting

[jinu4ever]

Hi all,

I want to query below table as such.
SELECT DISTINCT ID
FROM Table
ORDER by ID

Table
ID Field1
1 a
1 f
2 gh
2 fd
5 df

This would give me
ID
1
2
5

I also want to add on to the above query two more records 7 & 8
so i want the final table to look like
ID
1
2
5
7
8

How should i write the overall query?



Thx in advance.

 

[mahenkj2]

ID does not look unique, isn't it auto number?
Why you can not add 7 & 8 in your table directly? Can you elaborate?

 

[jinu4ever]

Mahenkj22
Sorry.. it's a very dumbed down example of what i wanted to do.
ID is meant to be ClientID in my database.

 

[mahenkj2]

Query should return out of that which is in the table. You want to add more data, why do not you do so in the table or in this query itself via a form!

 

[jinu4ever]

the reason i don't want to use a form is becauase i would run this query everyday but i want to add 7 & 8 to the list of clients. I dont want to use a form to do this everyday.

As i said before, the example above is a very dumbed down version. The final query would return about 60 rows and i want to add 4 clients there manually.

That's why i want to hardcode the addition of those clients.