Merging 2 SQLs

[Charisma Bypass]

Hi all, more SQL help needed please 

I need to merge this:

select * from TABLE1 where c_code = $this->c_code

Note;  * pulls c_id, c_code, c_amount, c_type, c_status, c_use,  c_expiry_date

and this SQL:

select count(c_id) as c_used from TABLE2 where c_id = x

Where x is the c_id from table1.

Hope this makes sense?  Thank You in advance.

[JasonD]

SELECT t1.*, COUNT(t2.c_id) AS c_used
FROM table1 t1 INNER JOIN table2 t2 USING (c_id)
WHERE t1.c_code = $this->c_code

[Charisma Bypass]

Hi Jason - many thanks 

I had to change the inner join to a left join, and add a group by clause at the end.  Would this have any bearing on anything?  Checked teh codebase and it appears to work OK.

Thank you for setting me on the right track - highly appreciated!

[JasonD]

Yeah, left join if there might not be any matching rows in table2. Group by if you are expecting more than one row.