[SOLVED] Easier way to do this query??

[gigantorTRON]

I have two tables that need to be queried as part of a php script.

 

table1

signId tableId clientId

 

table2

tableId latitude longitude

 

query:

SELECT latitude FROM table2 WHERE tableId IN (SELECT tableId FROM table1 WHERE signId = $_GET['id']);

 

Thanks for the help!

[cmgmyr]

try...

SELECT t2.latitude FROM table2 t2 INNER JOIN table1 t1 ON (t1.tableId = t2.tableId) WHERE t1.signId = $_GET['id'];

[gigantorTRON]

You Rock!