我如何加入这些表格?-HowwillIjointhesetables?

1  

You have not made relationship among tables, that's why you got the error here,

你没有建立表之间的关系，这就是为什么你在这里有错误，

    SELECT table1.column1, table2.column2...
    FROM table1 JOIN table2
    ON table1.common_field = table2.common_field; // (This part is missing in your code)

For further study http://www.tutorialspoint.com/sql/sql-using-joins.htm

为进一步研究http://www.tutorialspoint.com/sql/sql-using-joins.htm

Your code should look something like this,

你的代码应该是这样的，

SELECT  a.edi_transaction_id, a.sender_id, a.receiver_id, a.gs_number, a.isa_number, a.file_name,            
        b.edi_997_detail_id, b.no_of_trans,
        c.edi_transaction_etail_id, c.po_number,                    
        d.edi_doc_type_id, d.doc_type

FROM    (((edi_transaction a 
        left join edi_997_details b on a.edi_transaction_id = b.edi_transaction_id)
        left join edi_transaction_details c on a.edi_transaction_id = c.edi_transaction_id)
        left join edi_doc_type d on a.edi_doc_type_id = d.edi_doc_type_id)

WHERE   a.file_name like '%Your file Name%'      
        and c.po_number like '%Your file Name%'    
        and d.doc_type = 'your doc type'    
        and a.flag = 1 AND c.flag = 1;

Hope this will accomplish your task.

希望这能完成你的任务。

1  

Your need to learn JOIN sintaxis

你的学习需要学习。

either you need the ON clausule

要么你需要ON clausule

FROM MatrixEdiBundle:EdiTransactionDetail a 
JOIN Details b
  ON a.SomeID  = B.SomeID

Or you need a CROSS JOIN

或者你需要交叉连接

FROM MatrixEdiBundle:EdiTransactionDetail a 
CROSS JOIN Details b