Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inner join
Message
From
24/08/1999 02:05:21
 
 
To
All
General information
Forum:
Visual Basic
Category:
Other
Title:
Inner join
Miscellaneous
Thread ID:
00256940
Message ID:
00256940
Views:
56
Any body can help me .. how to use inner join in more than 1 table ?

example: I have 3 tables and I use inner join to combine 2 tables.

Select Sales.*, Stock.StockName, StockGroup.GroupName from Sales Inner Join Stock On Sales.StockCode = Stock.StockCode Inner join StockGroup.StockGroup On Stock.StockGroup = StockGroup.StockGroup

thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform