I need help with Joining tables in sql,. I tried alot of query, but Im really not getting anywhere. If someone can help lead me in the right path, it really would help. I have provided a txt file of the two table, Im trying to join together.
Simple inner join would be something like this
SELECT yf.PartNumber, yf.Total, yf.[Stock Range], yf.Shorten, ssr.Limit
From YF_Safety_Stock_Inventory12 yf
INNER JOIN Safety_ Stock_Requirments ssr ON yf.PartNumber = ssr.PartNumber
What exactly are you trying to get from the tables?
Thread moved to the 'Database Development' forum - which is where you should always post SQL questions (while SQL can be used in VB, it is certainly not specific to VB)
(2007, 2008, 2009, 2010, 2011, 2012) . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums
Classic VB FAQs (updated Oct 2010) ...Database Development FAQs/Tutorials (updated May 2011)
(includes fixing common VB errors) .......... (includes fixing common DB related errors, and [Classic VB] ADO tutorial /further steps, and [VB.Net] ADO.Net Tutorial).
Tutorial: How to automate Excel from VB6 (or VB5/VBA) .. SQL 'Select' statement formatter/checker .. Convert colour number to colour name .. FlexGrid: fill from recordset .. FlexGrid: AutoSize columns .. DB Reserved Words checker
Connection strings .. MDAC/Jet/ACE downloads .. SQL Server downloads .. MZTools (free upgrade for the VB6/VBA Editor)