Need Help With Joing Tables SQL

[Focus12]

Join Tables.txt


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.

[MarkT]

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?

[si_the_geek]

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)