Select statements

[punter]

Hi,

I hope I posted this in the right forum. It didn't seem specific enough for the other ones.

I have a select statement in a form that reads as follows:


Select [Port of Origin] from [Port of Origin]

It works great. It does exactly what I want it to do.

I want to add another field to the statement but it is from a differnet table. If it was to stand alone it would read as follows:

Select [VendorName] from Container_Vendor_Information

How would I combine these two statements? I have tried various things can't get it to work. Any thoughts?

Thanks so much in advance.

Eddie.

 

[boblarson]

Just a hint on how to learn how to do it. Go create a new query in the QBE grid and then go into SQL view to see the syntax.

 

[punter]

Thanks again Bob. That led me down the right path.


Eddie.