Criteria or Condition needed

L

Luis

I have the following querie:

Code Profit
H305 $350
H306 $306
H307 $307

I have created a query from two different tables and the
only profit I am missign is H305...I do not want to inout
it, but instead pull it from query above. Is there a way?

Ny New querie will look
Code Profit
H2560 $250
H305 ???? should be 350
H210 $756

Thank you again.
 
Top