SQLExecQuery - link database tables

MPullen

New Member
Joined
Apr 8, 2002
Messages
13
How do I link or join 2 tables using the SQLExecQuery command in Excel VBA?

Thanks
Michael
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

ChrisUK

Well-known Member
Joined
Sep 3, 2002
Messages
675
Hi.

The method you use to get the data is not relevant, it's the query string which is important.

To join two table you need a common field in both tables. For example consider a customer table and order table, the customer table holds information on your customer - customer number, name, address etc but the order table will just have a customerID field in. So to join them your SQL statement would be :

Select * from Customers, Orders
where Customer.CustomerNumber = Orders.CustomerID
Order by CustomerNumber, OrderNumber

Throw this at your database and await the information it send you back!

Hope this helps
 

MPullen

New Member
Joined
Apr 8, 2002
Messages
13
Thanks.
Seems to work.
I was using the INNER JOIN command, which didn't work.
 

Forum statistics

Threads
1,143,613
Messages
5,719,713
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top