On the SQL connection query problem!

Dear friends, Everybody is good, I want to do a join query view! Is this, A table for loss record, No repeat, The same name, Only one record, Operation number, To identify! B table for cutting records, Because the parts have deputy factory branch, So the same name accessories in the same [number] homework may in table two records, I think in the clearing time, Do a join query, The A table as a reference, The B table with the same [job number], The same [name] record, Just take the [date] or [ID] the most recorded the largest one! Condition: condition is B. number =a. operation number and B. =a. name and description, The B table, The same name record, How to write? Thank you!
A table fields: ID, job number, number, name, brand, origin, quantity
B table fields: ID, date, job number, number, name, brand, origin, quantity, unit price, amount
Inquiry: job number, serial number, product name, brand, origin, quantity, unit price, the amount of (B, job number, name the same record, only from the date of the largest entry or ID as the biggest record) thank you friends!

Started by Elliott at November 20, 2016 - 6:17 PM

Directly on the data and results.

Posted by Brook at November 26, 2016 - 6:40 PM