Xaoswolf's Journal: Access, woo hoo

Well, I'm building a Access database and I'm stuck.
You see, 2 or so years ago, I was doing this stuff in class, and it was rather simple, unfortunately, my long term memory seems to have decided that SQL commands weren't needed anymore and dumped them in favor of movie trivia.

What I'm trying to do is querry a table, then pull specific field from the results and put them into another table.

I picked up my access book from class, and wouldn't you know it, what I want to do isn't in it. Any ideas?

sumthin like dis

[FortKnox]

Try:
SELECT * from A as FIRST_TABLE, SELECT * FROM B AS SECOND_TABLE WHERE A.FIRST_TABLE_COLUMN='whatever' AND B.SECOND_TABLE_COLUMN='whatever';

Mind you, I'm no DBA, but that's the general idea.

Re:sumthin like dis

[Xaoswolf]

Thanks.

I think SQL(and the Access version) is one of those use it or lose it skills. Perhaps this little project will help me regain some of it.

Access

[bluse]

You are probably not using the SQL view for your queries so here is another option.

Change your query type to either append, update, or make table and the results of your query will be written to the desired table.

Hope this helps

Re:Access

[Xaoswolf]

Never thought of that. I used to use the SQL views, but got as far as typing SELECT this time before realising that I had forgotten it all.

On a side note, how'd I wind up being the lucky one to recieve you're first post?

First Post

[bluse]

Twas my first ever post, I hate to see ppl suffer when I can help.

I like to see what is happening on /. I've just been a voyeur up to this point, but my aversion to posting as an anonymous coward prompted me to create an account. (see how they push our buttons?)