Posts Tagged “SQL”
OK, this’ll make users of “proper databases” cringe but because MySQL doesn’t support sub-selects you can’t do the most obvious way of selecting records in one table that aren’t in another. Here’s how it’s done, with a clear explanation of why it works! select po.id from po left join pn on po.id=pn.id where pn.id is [...]
