who has military branches are confederate states army and infantry ?
SELECT DISTINCT var_uri where brack_open var_uri dbo_militaryBranch dbr_Confederate_States_Army sep_dot var_uri dbo_militaryBranch dbr_Infantry brack_close