My Sql Query

Discussion in 'MySQL' started by shahinfosoft, Jun 22, 2011.

0
  1. #1
    I want fetch data from 2 tables but i want all data from 1st table and i want some data from 2nd table.
    So how to fire mysql query?
    Please help me...
     
    shahinfosoft, Jun 22, 2011 IP
  2. plog

    plog Peon

    Messages:
    298
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    0
    #2
    Smells of a Left Inner Join, but we're going to need more information. What are the tables' structures, what data do you want from each, how are the tables linked?
     
    plog, Jun 23, 2011 IP
  3. siuda

    siuda Greenhorn

    Messages:
    46
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    You need to use primary key from table_1 and use JOIN to fetch data from table_2. If have a problem with that contact me by PM.
     
    siuda, Jun 23, 2011 IP