none
Tables Joining

Risposte

  • Hi,

    try something like this

    SELECT a.*, b.*, c.*
    FROM Tabl1 AS a JOIN Table2 AS b
    ON a.col1 = b.col1
    JOIN Table3 AS c
    ON b.col1 = c.col1
    /*
    and you can specify column name in select
    SELECT a.col1, a.col2, a.col3, b.col2, c.col4
    FROM Tabl1 AS a JOIN Table2 AS b
    ON a.col1 = b.col1
    JOIN Table3 AS c
    ON b.col1 = c.col1
    */

    More about JOIN

    I hope this is helpful.

    Elmozamil Elamir

    MyBlog


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid
    http://elmozamil.blogspot.com

    • Proposto come risposta SJohio giovedì 16 febbraio 2012 03:11
    • Contrassegnato come risposta Mr. WhartyModerator sabato 14 aprile 2012 10:13
    martedì 7 febbraio 2012 09:34