Do I use a Join statement?

[Enjoy Life]

I am not sure how to use join all that well. Here is my set up. I
have two tables. Tables are Orders and VendorDetails. I would like
to pull the Subtotals of all Orders that I have received an invoice
from the vendor on.

So, basically, if OrderID exists in the table VendorDetails, then give
me the Subtotal for the OrderID in the Orders table. OrderID is set
up with a relationship to both tables. Thanks.

-Darren

 

[Bob Barrows [MVP]]

I am not sure how to use join all that well. Here is my set up. I
have two tables. Tables are Orders and VendorDetails. I would like
to pull the Subtotals of all Orders that I have received an invoice
from the vendor on.

So, basically, if OrderID exists in the table VendorDetails, then give
me the Subtotal for the OrderID in the Orders table. OrderID is set
up with a relationship to both tables. Thanks.

-Darren

You should always tell us the type and version of database you are using. It
is always relevant.

It is always best when requesting help with a query to provide a few sample
rows of data in tabular format (just show us the minimum number of columns
needed to illustrate the problem). This will allow us to see the field
names. Next you should show us the results you wish to obtain from that
sample data. The keyword is "show" - do not describe the results: show us
the results you would want the query to return from the provided sample
data.

Bob Barrows

 

[Enjoy Life]

Thank you for the quick response Bob. Next time I will show you some
more details, that was my fault. Anyway, I figured out a solution.

-Darren