MySQL Forums
Forum List  »  General

Re: Select whats left from 1 table
Posted by: Manhao Chen
Date: June 29, 2014 04:03PM

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

Options: ReplyQuote


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.