Top "Multiple-tables" questions

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

How to join records from multiple object tables to a master table with a single query?

So I have a data model which is set up with a table that contains NAME, ID, and CONDITION columns …

sql jasper-reports inner-join multiple-tables
Should I use flat tables or a normalized database?

I have a web application that I am currently working on that uses a MySQL database for the back-end, and …

sql mysql normalization denormalization multiple-tables
mysql select query on two tables

I am trying to get a result from two tables without having a second query nested inside the first query …

mysql select multiple-tables
Multi Table Inheritance with rails 3

Are there standards or best practices yet when it comes to multi table inheritance in rails 3? So far the best …

ruby-on-rails multiple-tables sti
ASP.NET MVC 3 multiple Models to single Form

I'm learning ASP.NET MVC 3 and trying to create a View with a single form which is made up of …

asp.net-mvc asp.net-mvc-3 forms multiple-tables
Fetching single value from SQLite in android

I'm developing my firs app for android right now, I am using multiple tables to get and insert data. during …

java android sqlite multiple-tables
MySQL Query with multiple conditions and multiple tables

I have three tables products, properties and product_properties. The subset of table structures and values are given below: products …

mysql sql multiple-tables multiple-conditions
Joining 3 tables and retrieve all the records from all the tables

I am joining three tables (performing a full outer join) so that I can retrieve all the records from all …

sql database join multiple-tables
MySQL select DATETIME similar up to the minute

I have to comapre the results relative to the same time between two tables, but the time stamps differs of …

mysql datetime multiple-tables
Delete from table if the id doesn't exists in another table

I want to delete the id's from types that can't be found in types_photos but I don't know how …

sql sql-delete multiple-tables