MySQL Forums
Forum List  »  Newbie

Re: Query To Select and verify if item exists
Posted by: Alexandre Leal
Date: August 18, 2014 09:23AM

Sorry about the inconvenience. I've already solve the problem.

SELECT *, EXISTS(SELECT *
FROM table2 as tb2
JOIN table3 as tb3
ON tb3.id = tb2.Cust_Id
WHERE tb3.Name = 'Beth' and tb1.id = tb2.Item_id)
FROM table1 as tb1
Order By id asc;

Options: ReplyQuote


Subject
Written By
Posted
Re: Query To Select and verify if item exists
August 18, 2014 09:23AM


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.