displaying joined model data

I have two models in a ccv5 but I can't get a joined field to display. here is what I have.
Model: rq
Table: wrds_cf_CCT_CCTRequirements
Conditions: none
Fields: cf_id, item, type, duewk, viewlink, submitlink, notes, status
Order: duewk

Model: s
Table: wrdsw_cf_CCT_CCTSubmissions
Relation: blank
Associated Model: blank
Associative save / delete: NO
Foreign key: blank
Conditions:

<?php
     $user = \JFactory::getUser();
     return array("s.user_id" => $user->id);
    ?>

Join Conditions:

    <?php
    return array("s.itemid = rq.cf_id");
    ?>
    

Then front list
Columns list:
rq.item:Requirement
rq.type:Type
rq.duewk:Due
rq.notes:Notes
rq.viewlink:View
rq.submitlink:Submit
rq.status:Status
s.user_id:submitted

The debug dump shows:
Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `wrdsw_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Group`.`id` AS `Group.id`, `Group`.`parent_id` AS `Group.parent_id`, `Group`.`lft` AS `Group.lft`, `Group`.`rgt` AS `Group.rgt`, `Group`.`title` AS `Group.title` FROM `wrdsw_usergroups` AS `Group` ORDER BY `Group`.`parent_id` ASC, `Group`.`lft`
[2] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `wrdsw_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'CCT_Requirements' AND `Connection`.`published` = '1'
[3] => SELECT COUNT(`rq`.`cf_id`) AS `rq.count` FROM `wrdsw_cf_CCT_CCTRequirements` AS `rq`
[4] => SELECT `rq`.`cf_id` AS `rq.cf_id`, `rq`.`item` AS `rq.item`, `rq`.`type` AS `rq.type`, `rq`.`duewk` AS `rq.duewk`, `rq`.`viewlink` AS `rq.viewlink`, `rq`.`submitlink` AS `rq.submitlink`, `rq`.`notes` AS `rq.notes`, `rq`.`status` AS `rq.status` FROM `wrdsw_cf_CCT_CCTRequirements` AS `rq` ORDER BY `rq`.`duewk` LIMIT 30
)

there is no sql for the s model?

There is data in both tables and a sql run in phpMyAdmin yields results joined on rq.cf_id = s.itemid

ok, figured it out. I had to add the s.datesubmitted to the list of fields retrieved in the rq model section, makes some sense, but mostly obscure.