Top "Multiple-tables" questions

This tag will generally be used by those unfamiliar with SQL, asking basic questions about joins.

MySQL Keyword Search Across Multiple Tables

I have three tables in a MySQL database used in a music library application: The Genre table has columns: id …

Read More
mysql database search keyword multiple-tables
iOS program to use multiple UITableView in a single UIViewController

I am trying to implement 3 tables in a single segue in a storyboard. When one table is selected it will …

Read More
ios uitableview uiviewcontroller multiple-tables
Hive - grab from two tables without join

In MySQL, I can select from two tables without a join, like so: SELECT t1.value, t2.value FROM t1, …

Read More
optimization join hive multiple-tables
Create fulltext index on a VIEW

Is it possible to create a full text index on a VIEW? If so, given two columns column1 and column2 …

Read More
mysql view full-text-search multiple-tables
Using MAX with multiple tables

I have a four tables: products, pc, laptop, and printer. Products(maker, model, type) PC(code, model, speed, hd, cd, …

Read More
sql subquery union aggregate-functions multiple-tables