I need a little help with sql work.
I have three tables
I want to find records from tblOne with:
1) any twoid from tblTwo table
2) anythreeid from tblthree table
basically, I want to find records from tblOne when #1 or #2 happends.
Do I need to create two sql finding records from each table and combine?
Can I do this in one sql?
When I tried to inner join, it didn't bring me back everything.
select * from tblOne a inner join tblTwo b on a.twoid = b.twoid
inner join tblThree c on a.threeid = c.threeid