slect runtime variable

[Prellyan_Luxtintner]

Hey there,

I have a recordset A which returns X variable on a standard clientID filter which then forms part of a repeat region.
As part of this data set i wish to include a field from a different table based on the returned X of recordset A and the returned recordset of B which is a Y/N query

Is there a way to do this and if yes how so.

Thanks

[Prellyan_Luxtintner]

so far i have this which might give a better explanation

$colname_albumimage = "-1";
if (isset($GET_['albums.albumID'])) {
$colname_albumimage = $_GET_['albumfilter.albumID'];
}
mysql_select_db($database_rubymain, $rubymain);
$query_albumimage = sprintf("SELECT pictures.picfilepath FROM pictures WHERE pictures.albumimage = 'Y' AND pictures.albumID = %s", GetSQLValueString($colname_albumimage, "int"));
$albumimage = mysql_query($query_albumimage, $rubymain) or die(mysql_error());
$row_albumimage = mysql_fetch_assoc($albumimage);
$totalRows_albumimage = mysql_num_rows($albumimage);