I have two tables -
Item
- ItemID
- ItemName
- SalesTaxCodeID
- PurchaseTaxCodeID
TaxCode
- TaxCodeID
- Rate
In table Item, I have field SalesTaxCodeID and PurchaseTaxCodeID. Is it possible to select from the two tables so that I can get recordset of columns ItemName, SalesTaxCodeRate, PurchaseTaxCodeRate
Thanks
How to join tables?
Hot Topic
- OPENROWSET, querying external text file
- creating flat file and SQL Server 2005 hangs...
- Announcing SQL Server Everywhere Edition
- How can I sort on an aggregate
- Urgent .I dont have the Tools on the start menu.
- text box sending large amounts of text to next page Microsoft please help
- How to: Query Time only?
- Bulk Load XML into SQL using Schema File ...
- Need distributed service broker sample
- process cube
SQL Server
- Cannot create a connection to data source
- how do you call storprocedure in sql reporting?
- Bulk Insert Speed Problems
- Public role and explicit rights
- Trouble inserting multiple nodes during UPDATE
- SQL Server 2005 Success Audits
- how to get driopdown for year
- PROBLEM: Grouping tasks: Connections disappear ?
- Reusing a Chached Lookup component
- How to Choose "Cache Size" for a Lookup Transformation?
How to join tables?
roberto mariconda
from Item i
inner join TaxCode tcsales on (tcsales.TaxCodeID = i.SalesTaxCodeID)
inner join TaxCode tcpurchase on (tcpurchase.TaxCodeID = i.PurchaseTaxCodeID)
If the TaxCodeIDs in Item are nullable you need to change inner join to left outer join