Help with a SQL query

[scrupul0us]

heres my query which isnt working:

$query = 'select (select OnlineServiceId from OnlineService o where o.AccountId='.$accountid.') as oid, d.name from domainalias d where d.DomainId=oid';

basically i need todo this:

1) From table 'onlineservice' grab the 'onlineserviceid' that correlates to field 'accountid' which i pass as $accountid

2) using 'onlineserviceid' grab every record from table 'domainalias' where 'domainid' in that table matches 'onlinelineserviceid' from the previous table...

i think i might need to use an inner join, but I'm no good at these complex sql queries

any help is appreciated!

[scrupul0us]

bump

[cahva]

I have a little hangover so this might not be right 😉

$sql = "SELECT name FROM domainalias d 
		LEFT JOIN OnlineService o ON d.DomainId=o.AccountId 
		WHERE o.AccountId = {$accountid}";

[scrupul0us]

i used an inner join but thanks pointing me in the right direction:

$query = 'select d.Name from onlineservice o inner join domainalias d on d.domainid = o.onlineserviceid where o.accountid = '.$accountid;