Help with JOins

Hi,

I have these queries and i want to JOIN all of them to make one query.

Can anyone help me write this query

select mlc.*, invxf.*
From CommerceCenter..p21_view_inv_xref invxf left outer join
dbo.MikeLittle_Chevron mlc
on invxf.their_item_id=mlc.material
where delete_flag = 'N' AND
invxf.customer_id in
(66708, 70915, 67766, 71410, 67786, 87575, 88655)



select standard_cost as 'dxp cost',primary_supplier_id as 'supplier id'
from CommerceCenter..p21_view_inv_loc
where location_id=10002


select purchase_pricing_unit as 'oum'
from
CommerceCenter..p21_view_inv_mast



select name as 'supplier name'
from
CommerceCenter..p21_view_address
where name= 'supplier id'

---------------------------------------------------

I came this far when ran pulls the data

select mlc.* from pubs.dbo.MikeLittle_Chevron mlc
left join p21_view_inv_xref invxf on invxf.their_item_id = mlc.material and
invxf.customer_id = '66708'
left join CommerceCenter..p21_view_inv_loc il on invxf.inv_mast_uid =
il.inv_mast_uid and il.location_id = '10002'

On Thu, 16 Oct 2008 11:11:02 -0700, Farhan wrote:

>Hi,
>
>I have these queries and i want to JOIN all of them to make one query.
(snip)

Hi Farhan,

For questions such as these, the usual recommendation is to post the
following information:

* The structure of all tables involved in the problem. Please post as
CREATE TABLE statements, including all relevant columns, all
constraints, and all indexes.

* Some well-chosen rows of sample data to demonstrate the problem,
posted as INSERT statements.

* Expected results, and ideally a short description of the underlying
business logic.

See www.aspfaq.com/5006 for more information.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis