SQL noob: ANY and IN hmmm.

[jamkelvl]

 

Okay, so this is my current select statment...

 

<?php
// all other code omitted
$select = "SELECT * FROM jobs WHERE work_order_number = '' && ship_to != 'Tatry Non Profit Housing Corp.' ORDER BY ship_to, unit_number";
?>

 

What I want to do is also check if work_order_number is equal to ANY po_number IN another tabled called pos. So like...

 

<?php
// all other code omitted
$select = "SELECT * FROM jobs WHERE work_order_number = '' OR work_order_number = ANY(SELECT * po_number FROM pos) && ship_to != 'Tatry Non Profit Housing Corp.' ORDER BY ship_to, unit_number";
?>

 

Any help?

[fenway]

There is no question here.