help with a JOIN

[tqla]

Hello. I think this will be a JOIN but my to columns that the tables have in common have different names.

 

The 'allusers' table has an 'id' column and a 'name' column.

 

The 'doctors" table has an 'obj_id' column and a 'value' column.

 

The 'id' table in the 'allusers' table matches the 'obj_id' column in the 'doctors' table.

 

The 'value' column in the 'doctors' table will have a value of either 'patient' or 'provider'.

 

 

How can I query the 'doctors' table and get the 'obj_id' of every record that has 'provider' in the 'value' column and then cross reference that with the 'id' column in the 'allusers' table so I can make an array containing the names of 'allusers' who are providers?

[miancu]

try  something like:

 

SELECT a.* FROM allusters a

        INNER JOIN doctors d ON a.id=d.obj_id

WHERE d.value='provider'

 

if I understood the requirement, this should work to give the allusters that are providers.

hope this helps!

 

 

[tqla]

Thanks miancu! Inner Join! This will work I think. I just have to work with it a bit. Breaking out the INNER join docs now. Thanks again.