Alternative for LEFT OUTER JOIN
HI all, select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id I want an alternative for left outer join.. I cannot use left outer join for some purpose.. So i need an alternative for [...]

Answer Question   |  July 28, 2010  5:23 AM
LEFT JOIN, LEFT OUTER JOIN statement, SQL Left Outer Join, SQL statements

SQL Server Query Help Needed
I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I’m trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the Inventory Transaction table to the Shipment (Sales Order) tables [...]

Answer Question   |  February 6, 2009  10:39 PM
INNER JOIN, JOIN statement, LEFT JOIN, RIGHT JOIN, SQL, SQL queries, SQL Query, SQL Server development, SQL Server Query

LEFT JOIN depending on more conditions
I’m not sure what says the ansi norm about this SELECT * FROM a LEFT JOIN b ON b.mast_id = a.id AND b.flag = 1. Is it possible (by the ansi norm) to use in “ON” condition more then one boolean expression? Like in this case condition compounded by two expressions? Of course, meaning by [...]

Answer Question   |  October 13, 2008  8:01 AM
ANSI norm, Database programming, JOIN statement, LEFT JOIN