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

    martedì 7 febbraio 2012 09:34