DLookUP Function in Microsoft Access Query

Question

Good day dear memebers,

I created a query in Microsoft Access from a 'Products' DataTable where fields included were 'ProductName' & 'Buyer'. Also I have another DataTable 'Price' (not connected to the first DataTable) that contains the 'ProductPrice' field. What I want to do is to use the DlookUp function to get the Product Price from the 'Price' DataTable into my query to align it with the 'ProductName'.

Appreicate your kind help & support on this issue.

Regards,
Ali