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
[CODE=php]
"select expirydate from customer l,domain s
where l.cust_id = (select cust_id from customer where comp_name = '$compname') and s.domname = '$domname'";[/CODE]

[bips2005]

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