By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,939 Members | 1,684 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,939 IT Pros & Developers. It's quick & easy.

Linking Tables

P: 1
I made a new table by doing group-by max from table-A, through Query design. Now i need to include a new column from table-A that matches the content in the Max column(which i already done max group-by). I try to do some ways but its picking the whole data in Table-A( but i need only matching contents)
Mar 5 '15 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 2.5K+
P: 3,487
I'm not sure what you mean or what you are trying to do.

Typically, it is not a good practice to create a table based on calculated data from another table.

Also, if you add the field in Table-A to your query can't you add that to your new table as well?

I am a bit confused about what you are trying to do.
Mar 5 '15 #2

Expert 100+
P: 636
If I understand this correctly, I believe you need to save this Max/Grpup query as a stored query and then create another query using this Max/Group query and join it to Table A by its Primery Key field(s) (and the Max() field if it is not part of the PK). You can then add as many fields from table A as you like to this second query and only get rcors that match the Max/Group query.

I don't know if that helps (or is understandable)!?

Mar 5 '15 #3

P: 208

It is hard to decipher what you are attempting here. One thing to note as twinnyfo mentioned. If you are creating calculated values or a logical view of data this should be done with queries. Tables are used to store data, and you should not duplicate data in multiple tables. That causes a lot of issues. If you can clarify what it is you are trying to do we can try to help you do it :)

Mar 5 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.