ISSUE IS SOLVED

-----------------

I think this is an easy one...I need help with the 'JOIN' statement (or the appropriate statement to connect data from two tables).

I have the following separate statements that work to get me the data I want from each of the two separate tables.

From the ads table:

SELECT DISTINCT id , school
FROM ads

From the cb table:

SELECT title, link FROM cb

I want to connect the two when the column 'id' that is in the ads table = the column cb_id that is in the cb table.

Any help here?

Thanks

-------

ISSUE IS SOLVED

You may solve your problem with sql inner joining. You can follow this link Sql inner join - SQL tutorials | w3resource