MSSQL select query that has another another select
I have 2 tables

1. Invoices
2. Receipts 

An Invoice can have many receipts.
I'm doing something like
Select * from Invoices
I need to have all the ReceiptID for this invoice into 1 column.

How to do it??

10x
MSSQL select query that has another another select
===

I have 2 tables

1. Invoices
2. Receipts 

An Invoice can have many receipts.
I'm doing something like
Select * from Invoices
I need to have all the ReceiptID for this invoice into 1 column.

How to do it??

10x