join - Selecting multiple values different tables -


I am relatively new to MySQL.

I have 2 sets with the following structure 

  Products {pid-autoincrement, pname p_desc} services {sid-autoincrement s_name s_desc}

I am trying to select products or services that have the name '% & lt; Some keywords & gt;% '

I am using the query: 

  Select DISTINCT products. *, Services. * WHERE '% Mob%' or services._name like ''% mob% '' from products, services, but I'm getting many repetitive results.  
 Tried to experiment   
 
   p> Want to use Union like:  
  Choose products from products such as DISTINCT products.pid-autoincrement as id, products.pname AS name, Products.p_desc where products. Name '% mob%' Select Union Inter Services. As the side-autoincrement ID, names the services.s_name as services, services.s_desc as services from services where the services. Like '_name' '% mob%'

Comments

Post a Comment