SQL Statements

[spenn]

I Have one main query and two subqueries that are link to the main query. I
am writeing a program in C#.net and I am trying to use the SQL Statement but
the all the SQL statements are not combine. How Can I combine them to one??
I need One SQL Statement for all three. Thanks
Main Query called MainScreen:

SELECT tblOrders.OrderId, tblOrders.ORDNO, tblOrders.SUFFIX,
tblOrders.OrderRevision, tblOrders.ClientRef, tblOrders.Status,
tblOrderProducts.DESCRIPTION, tblOrders.OrderType, Clientt.Client,
EndUser.EndUser, EndUser.DESC
FROM ((tblOrderProducts INNER JOIN tblOrders ON tblOrderProducts.OrderId =
tblOrders.OrderId) LEFT JOIN Clientt ON tblOrders.OrderId = Clientt.OrderId)
LEFT JOIN EndUser ON tblOrders.OrderId = EndUser.OrderId
WHERE (((tblOrders.OrderId)=[tblOrderProducts].[OrderId]));

1st SubQuery called Clientt:

SELECT tblOrderContacts.BusName AS Client, tblOrderContacts.OrderId
FROM tblOrderContacts
WHERE (((tblOrderContacts.BusName)=IIf([tblOrderContacts].[ContactType]=3 Or
[tblOrderContacts].[ContactType]=4,[tblOrderContacts].[BusName])));

2nd Subquery name EndUser:

SELECT tblOrderContacts.BusName AS EndUser, tblOfferCat.DESC,
tblOrderContacts.OrderId
FROM tblOrderContacts LEFT JOIN tblOfferCat ON tblOrderContacts.OfferCatId =
tblOfferCat.OfferId
WHERE (((tblOrderContacts.BusName)=IIf([tblOrderContacts].[ContactType]=1 Or
[tblOrderContacts].[ContactType]=4,[tblOrderContacts].[BusName])));