1 Attachment(s)
Need Help With Joing Tables SQL
Attachment 90275
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.
Re: Need Help With Joing Tables SQL
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?
Re: Need Help With Joing Tables SQL
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)