That worked! Thank you thank you thank you Thank you!

Neil



>>Thanks,
>>Neil Preston
>Maybe first record has a spectacular touchdowns count :) Just kidding. Sorry couldn't resist.
>As I could see at first glance main isthe linker to both tables. Then I would put main in middle :
>

SELECT Reg_main.reg_year, Reg_main.last, Reg_main.first, Reg_main.city,;
>  Reg_main.st, Reg_fb.pos_num1, Reg_fb.pos_num2, Reg_fb.touchdowns,;
>  Reg_fb.rush_yds, Hs.hs_name, Hs.city, Hs.state;
> FROM  reg_fb INNER JOIN reg_main ;
>   ON  Reg_main.registr_id = Reg_fb.registr_id ;
>    INNER JOIN hs ;
>   ON  Reg_main.ceeb = Hs.ceeb ;
> WHERE Reg_main.reg_year = '99';
> ORDER BY Reg_main.last

Also I just separated the "On .." parts for they're easier to set correctly this way.
>Cetin