Recent content by simonsoot

simi, thanks for the quick reply. I read my question and realize I was not clear. for example, my original (above) query returned three results, and I need to pull more columns based on one field in the 3 results. does that make sense?

Fairly new to SQL, and I am a little stumped, though I bet the answer is easy. I have the below query set up and results; but then need to ALSO pull another field in the same table [cicmpy] based on the column named "Dealer". I assume this is a subquery? SELECT...

If anyone is familiar with installing EEM recently on a 2008 R2 server, we are running into issues. I have gone back and forth with Exact, and though helpful, they may be flying a little over my head (and right now they are closed since it is past 5pm). Big picture, we are currently running...

PHV, Thank you for your reply! After a better understanding if what the additional INNER JOIN did, I was able to alter and get what I want! thank you very much!

I hope this is placed in the correct forum...I am a novice to the forum and SQL, but using Access for what I thought would be a simple query: I have two tables, and I have written the below and is successful: SELECT DISTINCT dbo.imitmidx_sql.item_no, dbo.imitmidx_sql.item_desc_1...