With MOSS 2007 and WSS 3.0, we can use the Content Query Web Part (CQW or CQWP) to display SharePoint content from another source on a SharePoint page. This web part is rather nifty and one of my new favorite things about MOSS 2007. At first glance you tend to pass it by, then when you see what it can do, it is pretty cool. Imagine if you will, creating a list in SharePoint 2003 and then adding it as a web part to your WSS home page or SPS portal area. You are then limited to controlling the view through the Web Part Tool Pane by hiding or showing various columns. With the CQWP, you can now control how that content is displayed. You can wrap HTML code and styles to format the display nearly however you wish.
In this article I take what the ECM blog provided, and build upon it to show where to find internal column names, field types and provide a couple of samples so you can see how it all comes together.
Keep reading more in the full length article...