Since none of the tables in any of those queries are available to us (the forum users), it's impossible to give much useful insight on what needs to be done to replace the openquery call to a table (or series of tables).
If you just are looking for the basic syntax needed to select from a table, simply replace the "OPENQUERY(...)" with your table(s).