select ven_name from t_content where counter = 1 select type,vendor,store,counter from t_vendors where counter = 1 select ven_type, ven_name, ven_store, ven_id from t_vendor where ven_id = 1 select vendor from t_content where counter = 1