The image above explains the format I would like but entirely over-simplified to save space. The image above represents a single set of results from two unique queries in a single tab in dbviz.

My queries are as follows:

Select *
from
am_revenue.adtagref
where (ad_tag_name like '1%');
Select *
from
am_revenue.adtagref
where (ad_tag_name like '2%')

Normally, dbviz will just create two tabs of results when I run these queries at the same time. How do I force them into the same tab but with the second results appended to the right of the first results?

You can use UNION to join the results of two queries:
SELECT_query_1 U-N-I-O-N SELECT_query_2

The restriction is that both queries must have the same number of columns and each corresponding column has to have the same or implicitly (automatically) compatible data type. That is, query 1 column 1 and query 2 column 1 data types must match, q1 c2 and q2 c2 types must match, etc., for all the columns.

See "Books Online" under "UNION" for more details and/or restrictions.

SELECT
tag_f.ID AS ID1, tagf.adtagname AS adtagname1,
tag_g.ID AS ID2, tagg.adtagname AS adtagname2
FROM (
select *, row_number() over(order by id) as row_num
from am_revenue.adtag_ref
where (ad_tag_name like 'f%')
) as tag_f
FULL OUTER JOIN (
select *, row_number() over(order by id) as row_num
from am_revenue.adtag_ref
where (ad_tag_name like 'g%')
) AS tag_g ON tag_g.row_num = tag_f.row_num
ORDER BY tag_f.ID

SELECT
tag_f.ID AS ID1, tagf.adtagname AS adtagname1,
tag_g.ID AS ID2, tagg.adtagname AS adtagname2
FROM (
select *, row_number() over(order by id) as row_num
from am_revenue.adtag_ref
where (ad_tag_name like 'g%')
) AS tag_g
LEFT OUTER JOIN (
select *, row_number() over(order by id) as row_num
from am_revenue.adtag_ref
where (ad_tag_name like 'f%')
) as tag_f ON tag_g.row_num = tag_f.row_num
ORDER BY tag_f.ID