My sql query to return certain data from data base

See more:

MySQL

Hi guys,

First of all thank you for your help.

I have a question to ask.

I have a data table with 5 columns in it.
company-------- user:--------- description------- group ------- shared
companyA------- userA ------- This is gA ------- A ------------- No
companyB------- userB ------- This is gB ------- B ------------- yes

My query looks like this

select * FROM t_groups WHERE User_Name='userA' and Company_Name='CompanyA'

But i also want to return the groups from other users which are shared.

So i want to return the above queries groups but also the groups from other users that have been shared.