need to combine these two queries

[bips2005]

i have got two queries,

$sql1 = "select cust_id from customer where comp_name = '$compname'";
 
    $result = $DB->query($sql1);
    $result->fetchInto($row);
 
    $sql = "select expirydate from customer l,domain s where l.cust_id = '$row[0]' and s.domname =  '$domname'";

the first query retrieves cust_id from the table customer and i use it in the second query to obtain expirydate.

the problem here is that i need to combine these two queries into a single query to obtain the expiry date.
i am fairly new to this.

[r035198x]

i have got two queries,

$sql1 = "select cust_id from customer where comp_name = '$compname'";
 
    $result = $DB->query($sql1);
    $result->fetchInto($row);
 
    $sql = "select expirydate from customer l,domain s where l.cust_id = '$row[0]' and s.domname =  '$domname'";

the first query retrieves cust_id from the table customer and i use it in the second query to obtain expirydate.

the problem here is that i need to combine these two queries into a single query to obtain the expiry date.
i am fairly new to this.

Something like

"select expirydate from customer l,domain s
 where l.cust_id = (select cust_id from customer where comp_name = '$compname') and s.domname =  '$domname'";

[bips2005]

thanks that worked...
can we do the same thing using join
or was that one type of join