I have a table in ms-access with column names A to H
TableA
A B C D E F G H
how can i write a query to select all columns except B and F columns. Query result should be
A C D E G H
Do we have something like this
select * from TableA except B, F ?
No, we don't. You have to use
SELECT A, C, D, E, G, H
FROM TableA
And this is good if you ask me. SELECT * is evil enough.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With