Budd,

I am not sure what you are trying to acheive. When you say "one joined or conditonal statement" what would the condition be? If it is a particular ID from Table A, then you would have to pass that as a parameter or variable. If you want to want all values from both tables, that is the statement you have without the WHERE clauses.

If you can explain more about what it is you want I should be able to help.

Regards,

Ash