Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
a simple(?) join of 2 tables
I'm using MS Access during development so I guess there are some differences between Ansi and the MS Jet engine.... I found the solution using Group BY, although it will be a tough quest to integrate it with the rest of my (quite extensive) query... SELECT c.CustomerID FROM Customer c... -
a simple(?) join of 2 tables
Thnks again, but I get an syntax-error. As i'm not sure how the actual syntax should look...? what I tried is the exact code you provided in the example...any last tweaks?! Bart -
a simple(?) join of 2 tables
Thanks but could you give me an example? Select Customer.* From Customer, order Where customer.customerID=order.customerID ...? -
a simple(?) join of 2 tables
Hi! OK, somehow I got a blackout trying to formulate an answer for this question...I have 2 tables (actually many more, but for this they are irrelevant), say - customer - order the tables are joined by customerID. Within the order-table I use itemID to refer to the item bought. How would I...
