Mysql select from multiple tables for php.

**afidelino** · 09-07-2009

Hi,

I want some help with PHP mySql.
Can you please let me know how to make a query to talk with different tables?
I have some problem with the 2 tables with id name field. How can I give it an auto_increment nature?
please help me with the syntax atleast.

Thanks in advance.

**gvBlake** · 09-07-2009

SELECT from multiple MySQL Tables

Code:

SELECT fulltxt.pqid AS candidate_ft, citations.chid
FROM citations,fulltxt
WHERE citations.issn = fulltxt.issn
AND citations.volume = fulltxt.volume
AND citations.issue = fulltxt.issue
AND citations.year = fulltxt.year
AND citations.spage = fulltxt.spage
AND citations.pqid = ''
;

**bayz** · 09-07-2009

I have some huge database with around 50 tables & a another table to have the names of all those tables.
I want to know a query that will select from these table & show me a list of results to see at a glance. Ill be able to look as a whole?
Please help me if this can be done?

**MindSpace** · 09-07-2009

hey bayz you need to learn: Database Normalization

Normalization is a part of relational theory, which requires that each relation (AKA table) has a primary key. As a result, this article assumes that all tables have primary keys, without which a table cannot even be considered to be in first normal form.

Database normalization is a process by which an existing schema is modified to bring its component tables into compliance with a series of progressive normal forms.

**Reegan** · 09-07-2009

SELECT Syntax for multiple mysql tables.

Code:

SELECT
    [ALL | DISTINCT | DISTINCTROW ]
      [HIGH_PRIORITY]
      [STRAIGHT_JOIN]
      [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
      [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
    select_expr [, select_expr ...]
    [FROM table_references
    [WHERE where_condition]
    [GROUP BY {col_name | expr | position}
      [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_condition]
    [ORDER BY {col_name | expr | position}
      [ASC | DESC], ...]
    [LIMIT {[offset,] row_count | row_count OFFSET offset}]
    [PROCEDURE procedure_name(argument_list)]
    [INTO OUTFILE 'file_name' export_options
      | INTO DUMPFILE 'file_name'
      | INTO var_name [, var_name]]
    [FOR UPDATE | LOCK IN SHARE MODE]]