Hi all,
I would like to create one query that will combine records linked in a master/detail fashion. The results must be returned in one row. The reason for this is that I want to use this query to update data in an Excel spreadsheet.
Specifically, I have a master table that keeps products (productID, productName, productDesc). I also have a details table with the batches of each product (batch_ID, batch_ProductID, batch_date). Each product can have multiple batches.
I want with one query to return all the product details from the products table and all the related batches, BUT IN ONE ROW.
Is this possible?
Thanks for helping.
Marios