ok so i have
tab1
===============
companyid number version name .......
tab2
===============
name number version exe path..........
with data like
tab1
===============
4,34,"1.3.4", "bob"
6, 35,"1.3.7", "fred"
tab2
===============
4,34,"1.3.4", "bob.exe", "c:"
4,34,"1.3.4", "bobr.exe", "c:"
How do I query off of these tables to get a result set like
"1.3.4","bob","bob.exe", "c:"
I have tried inner joins, where in's, and everything else I could think of with no luck.
Is there a nice way to join 2 tables 1-m to get a result set?
if so how on earth do you do it?
tia
tab1
===============
companyid number version name .......
tab2
===============
name number version exe path..........
with data like
tab1
===============
4,34,"1.3.4", "bob"
6, 35,"1.3.7", "fred"
tab2
===============
4,34,"1.3.4", "bob.exe", "c:"
4,34,"1.3.4", "bobr.exe", "c:"
How do I query off of these tables to get a result set like
"1.3.4","bob","bob.exe", "c:"
I have tried inner joins, where in's, and everything else I could think of with no luck.
Is there a nice way to join 2 tables 1-m to get a result set?
if so how on earth do you do it?
tia