Consider using Outer Joins. Check the "Using Outer Joins" topic in Books
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: [url]http://www.sqlserverfaq.com[/url]
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - [url]http://www.sqlpass.org[/url]
"news.microsoft.com" <cramsundarmail.com> wrote in message
news:OspIpW9PDHA.304tk2msftngp13.phx.gbl...joining> Hi. I was wondering if this is possible.
> I have 2 tables that are related. I want to query both but without> them because some data wouldn't come back because of the join.
> Can I query two tables and have it come back in the same recordset using a
> stored procedure?