Hi,
I am trying to select parts data from 15 different tables

Tables are like this;
Table A
Id….Group….Desc……..Cost
1……1………Bolt………0.5
1……1………Nut…….…0.6
3……2………Screw….…0.4
4……3………Washer.….0.1

Table B
Id….Group….Desc……..Cost
1……1………Log……..1.5
2……2………Stick…….2.6
3……2………Leaf……..2.4
4……4………Branch…..1.1

Table C
Id….Group….Desc……..Cost
1……3………Plug……….1.9
2……4………Socket……2.8
3……4………Pin………..3.4
4……1………Needle……2.1

etc, etc

What I want to do is to pick out rows in each table by group number.
The group number may or may not exist in each table.
I don't want to combine the tables into one large table so it would be easy as each table has numerous columns that are unique to that particular table.
I know this is an old subject, but I can't find an answer here that fits my situation.
Any help or direction is appreciated.