Where do I put this Code?????

[shipwreck]

I had a problem... I wanted to know how could I use a query to show data from to different tables. Well Mr. tlbroadbent answered my question, but the answer is totally over my head. He must have assumed I know VB or that SQ stuff, WRONG answer. Anyway, where would this code go? not in my query statement??? "HELP"

tlbroadbent answer:

Select a.BSC,
a.FullName As CurrPerson, a.SSN As CurrSSN,
a.SkillLevel As CurrSkillLvl,
b.FullName As NewPerson, b.SSN As NewSSN,
b.SkillLevel As NewSkillLvl
From Onhand a Join Inbound b
On a.BSC=b.BSC


Thanks

 

[timgill]

Actually, you WOULD put it in your query. When you have the query open in design mode, change it to "SQL VIEW" and paste the code in. You can then switch back to design mode and it will convert it visually for you. You can switch to "SQL View" by right clicking on the area where you add tables (in design mode), and choose "SQL View".

Hope that helps.

Tim Tim Gill
Gill Consulting

http://www.dagills.com