Re: Select whats left from 1 table
thanks for that
looking at the query, i've rewritten it to work..
SELECT
tb_module.id,
tb_module.`name`,
tb_module.price
FROM
tb_module
LEFT JOIN tb_device_module ON tb_module.id = tb_device_module.fk_module_id
WHERE
tb_device_module.fk_device_id IS NULL
after analysing the query it doesn't appear to be what i'm after, i'm needing a query (i will need to pass a device id) to show me what are the remaining modules not in the tb_device_module table
Subject
Written By
Posted
Re: Select whats left from 1 table
June 29, 2014 04:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.